Hi all.
I have three two Participant (pk-partID), Registered Training (pk-regtranID, fk-partID).
I've created a form based on the Participant table with a subform for Registered Training that is viewed when you select the Registered Trainings tab but what is happening is that when a new record is entered for participant and then you switch to the Reg Trainings tab after added dates it doesn't save correctly. What works is that I have to first create the participant then save then go back and add information to the registered trainings.
I have referential integrity between the table but I want it to work so that when a participant in created their ID automatically shows under the Registered Training tab.
All help/suggestions are appreciated. Thanks, Anna
I have three two Participant (pk-partID), Registered Training (pk-regtranID, fk-partID).
I've created a form based on the Participant table with a subform for Registered Training that is viewed when you select the Registered Trainings tab but what is happening is that when a new record is entered for participant and then you switch to the Reg Trainings tab after added dates it doesn't save correctly. What works is that I have to first create the participant then save then go back and add information to the registered trainings.
I have referential integrity between the table but I want it to work so that when a participant in created their ID automatically shows under the Registered Training tab.
All help/suggestions are appreciated. Thanks, Anna