Load multiple tables with common and important field names

mansoorsheraz — Tue, 03 Jan 2023 20:10:45 GMT

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.

Re: Load multiple tables with common and important field names

rachel_delany — Wed, 04 Jan 2023 05:06:07 GMT

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.

topic Re: Load multiple tables with common and important field names in App Development

Load multiple tables with common and important field names

Re: Load multiple tables with common and important field names