Defined Value List In A Portal-Im Going Crazy

[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

[Ender]

I fixed your value list. There were a couple problems:

There was no relationship between the Manufacturer ID in Quote and Product 2. With this relationship in place, you can base your value list on that relationship (Product 2).

I would also recommend that you use a Manufacturer ID that is not the Manufacturer name, as names tend to change.

Quote_1aCopy.fp7.zip