AnsweredAssumed Answered

Lookup Not Working

Question asked by Kaps_1 on Dec 11, 2010
Latest reply on Dec 12, 2010 by Kaps_1


Lookup Not Working


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 ?