I wanna make my first linked table. I am writing my first datamodel. No i have made an example. My problem is that i have a field 'Relatie' in many tables. This causes a synthectic table.
Can someone build a Linked table so i have no field 'Relatie' in the tables: Verkooporders, Bestellingen en RMAorder. I wanna have this field in a linked table.
You don't have a synthetic table. I just combined the 3 tables in one. If you want to access the data just from one table (RMA orders), select the Type : RMA
