I have a data model with a single link table that joins in 7-8 tables on date and location ID. Is it possible to create a second link table to separate out 2 tables as I do not want them all to feed into a single link table. My question is how can I achieve this without creating Synthetic tables. I need the field names to be the same
Would appreciate any suggestions
Thanks
Brett