I need to create 2 tables. first one shows, inventory, quantity in order, transfer quantites and so on (about 8 different tables).
the second table shows exactly the same for the components according to the manufacturing specification of the selected item in the first table.
my problem is, that in each table is always one item field. there is no flag if it is an component or something else. secondly an item can sometimes also be a component. does anybody know how to solve this problem? load all tables twice or is there any better way?
