Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2008-09-30
1
Medium Priority
?
767 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 750 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

Learn how to optimize MySQL for your business need

With the increasing importance of apps & networks in both business & personal interconnections, perfor. has become one of the key metrics of successful communication. This ebook is a hands-on business-case-driven guide to understanding MySQL query parameter tuning & database perf

Question has a verified solution.

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

Your data is at risk. Probably more today that at any other time in history. There are simply more people with more access to the Web with bad intentions.
In this article, we’ll look at how to deploy ProxySQL.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
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 …

660 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