while maintaining exchange schemes.suppose creating a scheme to import the item master.how do we come to know that along with tiitm001 even few other tables like tiitm100 and tdinv100 have to be updated as well.
thnk u.

You must look at the referential integrity of the table fields from your parent table (tiitm001) to determine the dependency. Then each of these tables must be checked for dependencies and so forth. The Item Master has many levels (10+) deep in this dependency for Baan IV.

For example, tiitm001.cwar has referential integrity to tcmcs003.
And tcmcs003.cadr has referential integrity to tracs100.
And tracs100.ctyl has referential integrity to tcmcs010.
etc., etc., etc.

The recursion may stop if you have a table, such as tracs100, that has 0 records because the ref. integrity will not fail.

===============
-David B. Clark
dbclark79@juno.com