Solved

filemaker - Create new record that will have information populated from a field in another table

Posted on 2008-09-30
1
736 Views
Last Modified: 2013-11-24
I have a plugin in Filemaker 9 for windows called "POP3it" this plugin downloads messages from a specific email account and creates the following fields in a table called "messages":
1. Requestor
2. Date sent
3. Subject
4. Body

I have a Table for keeping work orders that i manuall enter. I want a button on the "Messages" table that when clicked, It will grab fields 1, 2, 3, and 4 and created a new record in a field called "details". I want to do this so that when i invoice, the customer see's their request, followed by my work description

anyone with any suggestions please assist me. If there needs to be any relationship pls let me know and any other detail as i am a novice in filemaker.

Please see my attachment for an illustration of what i'm envisioning
untitled.JPG
0
Comment
Question by:h20addikt
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 28

Accepted Solution

by:
lesouef earned 250 total points
ID: 22612162
you can either:
put all 4 fields in a variable, create a new record in the details table, then paste the variable in it.
or
link the message table to the details table using the message ID or something similar: this way, the details field could be auto-entered/from calculation.
if you choose the 1st way, it is still interesting to keep a link in between the tables to be able to find later on which message matches which details and vice-versa.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
Many companies are looking to get out of the datacenter business and to services like Microsoft Azure to provide Infrastructure as a Service (IaaS) solutions for legacy client server workloads, rather than continuing to make capital investments in h…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

732 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question