I have a script with a fact table and a different table with amounts. De fact table is linked to the Amount table with a ProjectID.
Also linked to the fact table is a master calendar based on the date field in the fact table. Now I have a date field in the Amount table as well (DateAmount).
How can I get this linked to the master calendar as well without creating loops etc? I searched the forum but couldn't find an answer that would help me fix it.
Thanks for your help!
To aviod Syn Keys you can create a table with all common fields inside, make a key using autonumber in parent tables and afterwards delete common fields from parent tables.