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

The Manufacturer_fk field in QuoteLI is not related to the products table. I believe you want to add a relationship from Manufacturer_fk to ManufacturerID. Then base your value list 'starting from' this new relationship.

Hey joe, No need to post the same question in multiple forums.