I have to create a new field without creating a synthetic key

[maternmi]

Hello,

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.

Thanks for your help!

Best regards,

Michael

[#2 · Accepted solution]

Synthetic keys are usually caused due to more than 1 similar field names in joining tables.  In that case you can try renaming the fields on which you don't the join to happen.

May be you can share a sample app for more clarity.