I have a deposit table and donations table and donors table
When a new donation is entered the foreign key to deposits is empty
Here i see all donations which belong to this deposit slip.
Now i in the donations screen I add 5 more deposit for example (they are not yet linked to a deposit slip)
Then when I go back to the deposits form and add a new record I would like to see all donations not yet linked but now being linked to this deposit slip.
How would I go about this?