multiple conditional value list

[mfrost]

To all databasepros: (FMP 5.0)

Here is the question I have (I hope I can express it well)

I have three fields:

product

supplier

order no.

The value list for the supplier field is a conditional value list. The condition is based on a relationship to a catalogue-of-goods-db. So it shows only those suppliers who actually sell the certain product. It works perfectly.

Now comes the problem: I want the order no. to be displayed of that certain supplier out of the catalogue-of-goods-db, too.

Whenever I have one and the same product, which is offered by two suppliers I want to choose between both. When I change the supplier, the order no. doesn't change.

Who can help?