6 Replies Latest reply on Dec 12, 2010 2:23 PM by Kaps_1

    Lookup Not Working

    Kaps_1

      Title

      Lookup Not Working

      Post

      I am trying to do a look up between two related tables "Products" and "Quotes". There is a related field between the two tables "Product Id".

      In the the Product table there are the fields "Product Name" & "Product Price".

      In the Quotes table there are the fields "Product Required" and "Unit Price". The Product Required is a value list and this is working correctly.The "Unit Price" is set up as a lookup to the "Product Price" based on the Product Required.

      I have attached screenshots showing how the lookup and the relationship diagram are configured. Any thoughts ? 

      relationships_jpeg.JPG