I have a question about if and how it may be possible to generate TWO records to be written from ONE data entry transaction.
I want to create a table that shows the relationships between two people.
I already have a table set up that has a row for each person with their name, DOB, phone number etc.
The process to enter relationships between people will be as follows;
The user will be presented with a screen and will pick a person’s name om a dropdown (Linked to the person table)(say MARY).
The user will then advance to the next field and choose relationship (eg WIFE) and then advance to the next field and choose a second person’s name (eg JOHN) and then advanc to the next field and pick a relationship HUSBAND.
When the user presses SAVE for that entry, I want two rows
to be written and contain the following fields
id, id MARY, WIFE, id JOHN id, idJOHN, HUSBAND, id MARY
Having such a table I can choose any person’s name and get a list of all their relationships
CAn anyone help suggest a way I can do this without having to require the user to enter two separate screen entries?