June 29, 200124 yr 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?
Create an account or sign in to comment