Problem:
AppGini does not allow a field to be Foreign Key and Unique Key at the same time.
Solution:
Set the field as Foreign in AppGini
Set the field as Unique in PhpMyAdmin
Problem solved.
Foreign Key and Unique Key at the same time
Foreign Key and Unique Key at the same time
AppGini 22.14 - xampp 3.3.0 - PHP 7.4.30 - Summary reports - Calendar - Mass update - Messages - AppGiniHelper
Re: Foreign Key and Unique Key at the same time
I'll modify this restriction in future releases ... notice that this (foreign key AND unique) would create a one-to-one relation between the two tables rather than one-to-many.
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.
Re: Foreign Key and Unique Key at the same time
Thanks for alerting about this.
But in my case it is exactly what I need to do in this table.
But in my case it is exactly what I need to do in this table.
AppGini 22.14 - xampp 3.3.0 - PHP 7.4.30 - Summary reports - Calendar - Mass update - Messages - AppGiniHelper