4 Replies Latest reply on Jan 17, 2015 1:53 AM by jms1882

    How to select a field from a table based on input in another table


      This should be very simple, but I'm new to Filemaker....  I've gone thru the basics and advanced training books but can't find a description of how to do it.


      I have a relationship between two tables, based on a unique part number - the same part number appears In both tables. 


      In a layout the user selects the part number and colour of the part through two drop down lists.


      I then want to pull onto the layout a single price for the part - from a price table.

      The price table has the part number, and three fields - a different price for each of the three colours.


      I think I could write a script with If then else to select the right price... but there must be a way of just selecting the right price without scripting.

      Any pointers - to manuals, refining the search or examples much appreciated!!


      thanks John.