h20addikt
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.