I am developing an app in which there are 2 tables: a parent and a child. The difference is that, in my case, the child table is generated first and, if the user decides to keep the information then a record is generated in the parent table and the child table is connected to its parent. The field in the child table that connects to its parent is temporarily filled with a value of -1. The user who types the information may decide to keep or not the records in the child table and it is at this time when a record in the parent table is generated or not. Meanwhile, the records in the child table have a tamporary value of -1 in the field that will connect to its parent table and this causes me not to be able to define a foreign key.
Please advice.
Respectfully,
Jorge Maldonado