Defined Value List In A Portal

[joemacgruder]

I am going crazy. I'm sure that there are many posts relating to this subject but I cant find them. Someone please help me.

I have two tables (FMP7) One is manufacturers and one is products. I want to choose the manufacturer and then only get the items related to that manufacturer when I am in a table I have named QUOTES. I have related the manufacturers and products table with a field called MANUFACTURERS_ID. I have defined a value list which should only relate the product to the manufacturers table and it only returns <no values defined> from the products drop down list (in the portal, in the quotes table) This is killing me. Please help. And put it in the easiest laymans terms possible. Thanks in advance for your help! I am attaching a copy of my file so maybe someone can look at it and help.

Quote_1aCopy.zip

[H.P.]

Here's fix: manufacturers related to products

check out the relationships diagram and the Quote Table layout... it is self-explanatory.... Click on the manufacturer field to select a manufacturer.. it will display only related products from that manufacturer...

G'luck.

Quote_1aCopy.zip