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

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
h20addiktAsked:
Who is Participating?
 
lesouefCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.