Title
Multiple relationship per table workaround
Post
Hi guys!
I have the following situation: see screenshot
The two tables 'AWF1' & 'AWF2' need to be related to the 'uitkeringen' table AND to the 'contactpersonen' table.
How can I do this?
'AWF1' & 'AWF2' contain fundinformation about a person ('contactpersonen') the table 'uitkeringen' is used as a portal and will be used to keep track of payments for both funds.
I hope Im clear enough and somebody can help me out.
You are not copying any tables by doing this. You are simply duplicating the reference to the table. If you follow the steps for duplicating a table occurrence as spelled out in the tutorial for which I provided a link, you can hover the mouse over the arrow in the top left corner of each table occurrence box and see that both refer to the same table.