I have number of tables namely contract table, budget table, Dispatch table, Invoice table, Expense voucher tables. In that CONTRACTNO is link field.
Link field contractno will appear in all above noted tables. Each table has child tables. all tables are concatenated based on the requirement.
My question is need to separate the Finished contract & Unfinished Contract. Finished Contract which means, a contract should completed all data entry process on above noted tables. I do update Contract tables as Finished flag when contract is complete, this flag should not effect in remaining tables.
I need the Finished flag should effect in all tables.... How should i connect tables for this