Dear Forum,
I would like to create a main form and a subform. However, I don't want to use the ID of the main form as the foreign key in the subform.
Instead, I want to use another field, ID2 (unique), as the foreign key. This ID2 is also unique across all other tables. No matter what I try, the ID is always used as the foreign key. I have also adjusted it in the "pages" settings. I need this to create a photo table as a subform for multiple tables.
Does anyone know a solution? Thank you very much,
best regards Manuel.
You are running the latest release of DaDaBIK
In case you want to upgrade to a more powerful edition (from Pro to Enterprise/Platinum, from Enterprise to Platinum) please contact us.
mysql version: 10.6.12-MariaDB-0ubuntu0.22.04.1
Web server: nginx/1.24.0
Client: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36 OPR/95.0.0.0
I would like to create a main form and a subform. However, I don't want to use the ID of the main form as the foreign key in the subform.
Instead, I want to use another field, ID2 (unique), as the foreign key. This ID2 is also unique across all other tables. No matter what I try, the ID is always used as the foreign key. I have also adjusted it in the "pages" settings. I need this to create a photo table as a subform for multiple tables.
Does anyone know a solution? Thank you very much,
best regards Manuel.
Your current DaDaBIK version
You are using DaDaBIK version 11.10-Elba enterprise, installed on 02.09.2023 (installation code: 1907564f2723317ba7), the latest version of DaDaBIK is 11.10-Elba released on 13.07.2023You are running the latest release of DaDaBIK
In case you want to upgrade to a more powerful edition (from Pro to Enterprise/Platinum, from Enterprise to Platinum) please contact us.
System info
PHP Version: 8.1.23mysql version: 10.6.12-MariaDB-0ubuntu0.22.04.1
Web server: nginx/1.24.0
Client: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36 OPR/95.0.0.0
