I have a table Container and a table ContainerDetails.
The ContainerDetails contains more information for each of the entries in the Container table.
I need to create a 1:1 relation between those two and tried to do this with a dropdown in the ContainerDetails table/form. AppGini can not create the code anymore throwing this error:
Why should this not be possible? If ue UNIQUE is set in the target table (ContainerDetails) one could only open a single entry for each of the records in Container in the ContainerDetails .... done .... but this seems to be impossible from the AppGini settings.Error checking:
Field 'ecomo_ContainerSpezifika.ID_Container' cannot be a foreign key and a unique field at the same time.
Of course, I can adjust this later on in the database (changing table structure of ContainerDetails), but it seems to me that either I am doing some AppGini handling wrong, or it's an unjustified error (in my use case).
Why two tables? I want to have a clean view for one usergroup, but another usergroup should see more details. I could do this with hooks by hiding these unwanted fields, but it seems much straighter to me not display them at all (never trust user input ... and such).
If you suggest some other way to realize my situation with AppGini, great. As I am quite new to AppGini, you might also suggest using the hooks variant with only one Container table which holds some more details than it does at this time.
Olaf