how would I tackle foreign keys (FK). Say that I have 2 tables. Student and Student Additional Info. In Student, I have StudentID as PK. I then want to save it so that when I insert a row in Student Additional Info, I can update a column in that table with my saved StudentId which becomes the FK in this table.
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| (SOLVED!)I need a HELP of a Wix Expert! | 16 | 2273 | February 20, 2019 | |
| Autoincrement dataset column | 5 | 605 | August 7, 2021 | |
| Creating Unique ID at the time of Submission | 26 | 2918 | September 7, 2021 | |
| Create a user id | 8 | 1151 | July 11, 2018 | |
| Database allows new entries with the same primary key | 4 | 295 | February 27, 2018 |