Is there any way to "add" a record as a child to a parent table, when the child record already exists?
ParentID (Primary Key)
ChildID (Primary Key)
ParentID (Foreign Key to Parents.ParentID. Nullable.)
Children table gets populated first by some other process. Some records need to be linked to a ParentID.
- Create another table with a 1:1 relationship to the existing Children
table, and move ParentID foreign key column to this new table.
- Maximize Children table, update desired record's ParentID, go
back to Parents table.
Just want to be sure I'm not missing some other way of doing this directly from the Parents screen, without the added complexity of another table.