Solved

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

Posted on 2008-09-30
1
706 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
Comment Utility
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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

This collection of functions covers all the normal rounding methods of just about any numeric value.
Never store passwords in plain text or just their hash: it seems a no-brainier, but there are still plenty of people doing that. I present the why and how on this subject, offering my own real life solution that you can implement right away, bringin…
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…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

744 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now