I have an application which is used to register students for an event.
There are two records: students and household. The students record contains
information about the individual student, e.g. name, birthdate, grade. The
household record contains the information about the household; e.g. the
address, parents names, phone number. There is an autonumber field in the
household record to uniquely identify each household. There is also a field
in the student record containing the family id to which the student belongs.
I have a form which shows all the information for a student. It's
datasource is a join query between students and household. You can enter
all the student information and all the household information without any
problem. I have a "new record" button which does a GoToRecord acNewRec.
This works great for adding a totally new student; it automatically
generates a new family id and sets the value in a new student record.
What I want to do is have an "add sibling" button. This would create a new
student record with the same family id as the current one. So the form
should show the new student information blank but the same household
information.
Any suggestions as to how to accomplish that?