Value lists in related tables

[tomislaw]

Also, it is a app for a print house. In the table A i must 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 1 that display values from records in table B. In field 3 (table A) should be listed only the paper weights for chosen paper manufacturers and chosen papers from records in table B. When all fields are matched, then are tables A and B related, so that i can pick other needed data from table B . It will bee nice when its possible to permit changing records in table B using the value-lists in the table A.

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 (self-joins) between table occurrences if it was just in one table. But with 2 tables, i have no idea.

P.S.

Sorry form my bad english.

[Tim W]

Hi,

I think this thread will help, if not post again.

Cascading Value Lists

HTH,

Tim