Help - Error message - adding field in one table corrupts data

[duthiedon]

Have developed a database for our training team to manage their training schedules. The one course schedule form (see attached), enables the user to add a course schedule, and then the associated participants. The main form is linked to a table called "tbl_schedule" and the sub-form is associated with a table called "tbl_participants" and they're linked by a field called "schedule_ID". The participants are linked to a table called "tbl_contacts". What I want to do, is that if the contact doesn't exist in the tbl_contacts, they can hit the button "New Participant", and then another form is popped up, that will then allow the user to complete the contact information, and then when closed, the participant is added to the list. I've tried several things, from having the pop up form have the same filter as the existing sub-form with a sub-form to contacts, but i keep getting the data corrupted. Is there an easier way to accomplish this? I'm not an access or database guru, so any help would be greatly appreciated.

 

[MStef]

As I can see, you have got 3 tables: "tbl_schedule" (main form), "tbl_participants" (sub form), and "tbl_contacts" (another form). But, you say (hereafter) "What I want do do, is that if the contact doesn't exist in the "tbl_contacts", they can hit the button "New Participant" and s.o."
What do you need, a new record in "tbl_contacts" or in "tbl_participant" ???

 

[duthiedon]

Thanks for your reply, it's greatly appreciated. Basically a new record in table tbl_contact, and then the ID field that's created in tbl_contact would then create a new record in tbl_particpants with the linked field. Does that clarify? Any help would be greatly assisted. Thought of a pop-up window that would create the contact, and then as it exited created the new record in tbl_participant but not sure how to do that.