I have to create a new field without creating a synthetic key
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.
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.
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.
