Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Related data query - excuse the pun


Recommended Posts

Hmm, second question in as many days - seems php & mysql is easier for me to understand than filemakers db structure & inner workings.


Well the question is I have a layout in which the users will be entering in various data to calculate prices but i need to bring in a value list from a related table for one part of the form - it will need to display the item name but use the item price from the table and store the itemID into the estimate form itempriceID in the related table.


Any ideas as I have read the manual and a couple of other books but it just doesnt appear as easy as it would be with php/mysql.



Link to comment
Share on other sites

Use this trick :)


Umm, that would be the use of lookups. You want a price field in your local table to look up values from a price field in a related table based on same item name (or same item ID code, etc etc)

Link to comment
Share on other sites

Oh dear, I don't think I explained that too well having read it back again. In my layout I have a value list that is generated by a related table and what I need to do is use the value of the selected item from the related table in another field for the price.

Link to comment
Share on other sites

okay I have resolved the price in another field part myself based on a selection from a value list. But, is there anyway I can do this ??


I have five fields in one table and would like to use 3 of them to create the text in a value list for use on a different layout and the ID as the hook to another field for looking up a price.



Link to comment
Share on other sites

This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Create New...

Important Information

Terms of Use