Forum Stats

  • 3,780,903 Users
  • 2,254,454 Discussions
  • 7,879,490 Comments

Discussions

Switching column(s) used in FK?

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:


Image


Best Answer

Answers

  • Mike Kutz
    Mike Kutz Member Posts: 5,942 Silver Crown

    It was the 2nd picture I needed.

    Thanks

    MK

    Dave Schleis