Page 1 of 1

Annoyance 5.75: No 1:1 relation possible

Posted: 2019-06-24 17:02
by onoehring
Hi,

I asked here ( viewtopic.php?f=2&t=3038&p=10340#p10112 ) if a 1:1 relation is possible, and it seems that this is not the case yet.
As this might be an error made by the user when creating the application in AG a warning seems to me better than to show an error. I actually want my PK to show up in a second table (be FK) and want it to be unique so create a 1:1 relation.
I do not really see a reason, even thinking about your internal coding, why this is forbidden - so, I ask you to make this possible.

Why this is "important" too: If I change the field in the database to unique I get the desired, but the application will always show it as a mismatch between AG definition and actual DB.


Thanks
Olaf

Re: Annoyance 5.75: No 1:1 relation possible

Posted: 2019-06-26 08:18
by onoehring
Hi,

pbötcher pointed me to make this a feature request. ... Yes, it would be great to have that opportunity.
Olaf

Re: Annoyance 5.75: No 1:1 relation possible

Posted: 2019-07-03 12:39
by a.gneady
To clarify, this issue is not specific to 5.75 ... Supporting one-to-one relationship is on our to-do list for testing (you're right @Olaf about there being nothing to prevent it in the codebase, but we just need to make some tests to make sure it works as expected). So expect to see it very soon.