How to apply a flag into all connected tables

[#1]

Hi all,

         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

Regards

Vignesh Babu.CV

[ashwanin]

Hi Vignesh,

Please attach some sample data.

[deepakqlikview_123]

Hi Vignesh,

You cbelow condition to set flag,

If(Fieldname= 'Finished contract',1,0) as Flag,

In this way you will set flag 1 for Finished prod and 0 for unfinished prod.

I do not know where u have concatenated your tables.But you have to use this condition for each one where u need to set a flags.

Thanks,

Deepak

Thanks,

Deepak