Solved

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

Posted on 2008-09-30
1
731 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
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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

Suggested Solutions

Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
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…
Viewers will learn the different options available in the Backstage view in Excel 2013.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

685 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