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.
I have been able to resolve the synthetic keys but now loops are coming which I am, unable to resolve:
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.