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

    jms1882

      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.