I have to create a new field without creating a synthetic key
in our company we have a data modell. For my application I've created three new tables. In each table are fields which I need to create a new field calling "Pickup_Reliability_Type". I tried to join them but the consequence is a synthatic key.
What can I do to avoid this problem? Maybe there is a simple way.
I attached a word file with the used syntax for the three tables and for the new field.