Annoyance 5.75: No 1:1 relation possible

Please report bugs and any annoyances here. Kindly include all possible details: steps to reproduce, expected result, actual result, screenshots, ... etc.
Post Reply
onoehring
Veteran Member
Posts: 248
Joined: 2019-05-21 22:42
Contact:

Annoyance 5.75: No 1:1 relation possible

Post by onoehring » 2019-06-24 17:02

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

onoehring
Veteran Member
Posts: 248
Joined: 2019-05-21 22:42
Contact:

Re: Annoyance 5.75: No 1:1 relation possible

Post by onoehring » 2019-06-26 08:18

Hi,

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

User avatar
a.gneady
Site Admin
Posts: 1021
Joined: 2012-09-27 14:46
Contact:

Re: Annoyance 5.75: No 1:1 relation possible

Post by a.gneady » 2019-07-03 12:39

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.
:idea: Learn all the tips and tricks of customizing AppGini apps through our online course.

:arrow: Mass Update plugin: Update multiple records at once and improve your workflow efficiency.

:arrow: Summary Reports plugin: Build powerful reports and charts for your AppGini apps.

:arrow: Search Page Maker: Compose user-friendly yet powerful search pages for your AppGini apps.

Post Reply