multiple relationships

[tomislaw]

I have 2 tables.

Table A with a relationship to table B. In the table A should be possible to chose values from field 1 in table B. So long so good. Now, i should bee able to chose, in table A, values from field 2 in table B. But only values that are related to values in field 1. In the same way i should bee able to choose values in table A from table B, from field 3, but only values that are related to field 1 and 2.

Table B.

Also, in field 1 a have manufacturers, in field 2 i have products lines, and in field 3 i have products.

When I choose some manufacturer, in the second field should be visible (possible to choose) only product lines from this manufacturer, and in field 3 should be visible (possible to choose) only products from this product line.

This should be not a problem to handle in the table B , but I need this in table As an relationship that is only related to this specific product so that i can pick some other data (fields) from this record in table B to table A. And its should be 2 times. The record in table A has always 2 records from table B.

Any idea?

P.S.

Sorry for my bad english language. I hope someone had understand what is on my mind. -)

[jteich]

Sounds like your entities are not defined usefully.

What does Table A contain, what about Table B?

-jens

[comment]

See if this helps.

[tomislaw]

Thanks for quick replay. But this, what veteran posts, is not what i need. Also, it is a app for a print house. In the table A i must to make calculations for the print cost. In the table B i have papers. 15-20 paper manufacturer. Every manufacturer has a couple kind of papers, and the papers have various weights. Its should bee possible, in table A field 1, to choose all of the manufacturer. Then in field 2 (table A) should be possible only to choose papers that are provided by chosen manufacturer. In field 3 (table A) should be listed only the paper weights for chosen paper manufacturers and chosen papers.

And all this twice. One time for the paper that is used for the booklet, and second time for the paper that is used for the cover.

All off this is not a problem to make via multiple relationships between table occurrences if it was just in one table. But with 2 tables, i have no idea.

[CoZiMan]

What you are looking for are 'conditional value lists'

Please use the 'Value List'forum here and you will find several good examples.

http://www.fmforums.com/forum/showforum.php?fid/34/

[tomislaw]

Thanks for the suggestion. I didn't know where to post because this is both, and a relationship and an value list depending.