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 ?