Query resulting in a table

General Information about upcoming products, upgrades, etc.
Posts: 1
Joined: Thu Sep 30, 2004 1:55 am
Location: Barcelona, Spain
PostPosted: Thu Sep 30, 2004 2:47 am
Hi, I'm very new at FM and I can't find relevant help anywhere I looked. I have built a contacts database improving the template given by FM7. I have added a field called "type of contact" with a list of fixed values to choose from (client, supplier, employee). I want the results of the query "Find me all the clients with their companies" displayed in a table, so that I can use it for another database that I am building called "Estimates to Clients". I would be very grateful for any ideas. Thanks!
SeedCode Staff
SeedCode Staff
Posts: 2760
Joined: Thu Nov 20, 2003 11:01 am
PostPosted: Fri Nov 26, 2004 6:55 am
Hi. Sounds like you want to define a Value List based on the contents of two fields in clients (the client and their company). Since you may want the value list to also include the client's ID number (and a value list can only show two fields) you may need to build a calculation that concatenates the client and company into one field so that you can use it in your value list.

Does that help?
John Sindelar
PostPosted: Tue Aug 30, 2005 7:44 am
You could also try defining a relationship from your future database to your current database. Then the second database can pull the value from the previous (master) database.

Return to FileMaker Products (General)

Who is online

Users browsing this forum: No registered users and 1 guest

Follow us: