another noob question about SDDM 20.2
In one relationship, the Logical Model is using a pair of Unique Not Null columns instead of the surrogate key.
How do I tell the Logical Model (and hence Relational Model) to use the PK instead of the UK?
If I adjust the Logical Design manually ( Browser - Logical Model - Relations ), I don't see the how to do it. (I could very easily be blind)
If I adjust the Relational Design manually, (Browser - Relational models - Foreign keys), I get an error. "Incomplete FK definition". (see Image)
What am I doing wrong? or is this a corrupt model? (or a bug with SDDM?)
Thanks
MK
Data Model on GitHub Repo:
MikeKutz/Data-ETL-Wizard (0 Bytes)
Image
