I am trying to get a 1:1 relationship recognized by DBFront.
I have a main and secondary table, where I have a UNIQUE constraint on an index that points to a column on the main table.
DBFront is currently just recognizing this as a 1:M relationship, and shows a new tab with one record in a grid that needs to be selected in order to edit. This works, but is clunky.
How can I get this to show up as a 1:1 relationship?
Currently dbFront recognizes 1:1 relationships when the PK (Primary Key) of the child table is joined to the PK of the parent table.