Help with Value Lists?

[Masood Bacchus]

I'm using Filemaker Pro Advance 10 to make a simple invoice for line items of different products, each with varying colours.  I, however, can not seem to get it to work.

 

I created a table of products, whose layout has a portal to another table.  This is where, using a drop down list, the varying colours of the product are input.  The colours are listed in yet other table.  Some products can have a limited number of colours while others have access to all colours.

 

Ideally, on the invoice, by line item, The product is selected in one field and then one of the colours relevant to that product is selected from a drop down list.

 

How do I make this happen?  I have tried doing a conditional value list with no luck, but I believe I am lacking something.

 

Please assist if possible....

[comment]

Assuming you have:

 

... LineItems >- Products -< ProductColors >- Colors

 

define a value list using values from Colors::ColorID, include only related values starting from Products.

[Masood Bacchus]

Sorry for the late reply. Your information was helpful and I solved it. Thanks!