I’m working on a database for an event that takes place next week. Because there were so many data items for each person, I have split the main data into 3 tables:
- MAINPARTICIPANTS (primary key – autonumber “participantID”
- MAINSPORTS (primary key is an autonumber, secondary key is “participantID”
- MAINTRANSPORTATION (primary key is an autonumber, secondary key is “participantID.”
Although there is probably a better way to structure the data, I don’t have time to do that. My problem is that when the user adds a person to MAINPARTICIPANTS, I need it to add a record to MAINSPORTS and MAINTRANSPORTATION (with the same participantID), but haven’t figured that out.
Urgently need help!! Thanks!!!