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
User avatar
onoehring
AppGini Super Hero
AppGini Super Hero
Posts: 1156
Joined: 2019-05-21 22:42
Location: Germany
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

User avatar
onoehring
AppGini Super Hero
AppGini Super Hero
Posts: 1156
Joined: 2019-05-21 22:42
Location: Germany
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: 1281
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: AppGini plugins to add more power to your apps:
  • DataTalk is an innovative AppGini plugin based on ChatGPT that allows you to interact with your AppGini database using natural language questions, without writing any SQL. Check the demo video
  • Mass Update plugin: Update multiple records at once and improve your workflow efficiency.
  • Check our other plugins and get a generous discount of up to 30% when buying 2 or more plugins.

Post Reply