Load multiple tables with common and important field names

[mansoorsheraz]

Hello,

I have three tables where the relation between the fields is important but I cannot load them all as they create a synthetic key. Here is the structure:

findings can have actions

findings can be assigned to their own contractors

actions can be assigned to their own contractors

data for contractors come from one table only

How to resolve this? There are so many fields in these tables, Concatenation doesn't look to be good as the script will get way too long. 200 plus fields.

Any solution is appreciated.

Update:

I have been able to resolve the synthetic keys but now loops are coming which I am, unable to resolve:

Regards.

[rachel_delany]

I think you would potentially have to create 2 copies of the tblFinding table, one to connect to tblActions and one to connect to tblContractor

That is the only way I can think you can avoid the loops.