Hi all,
I've semi-recreated a database I'm trying to make, a Conference Scheduler. I'm pasting an image, below, of the relationships I have established. Here's what I'm trying to do:
I have a form that opens a report to show the current agenda for the overall main conference. Each Day of the conference has a button whereby a user may add an agenda item. (Example: "BIG CONFERENCE" has Conference Days 1 and 2, each with their own agenda:
Day 1: 8am - 10am - Agenda Topic 1
Day 1: 10am - 2pm - Agenda Topic 2
Day 2: 10am - 11:30am - Agenda Topic 1
Day 2: 11:30am - 1pm - Agenda Topic 2
Day 2: 1pm - 4pm - Agenda Topic 3
What I am trying to do is add an agenda item, but it's not linking up. It will pop up the proper form, but I get the error, "You cannot add or change a record because a related record is required in table 'tbl_Conference_Day'
Is it apparent to anyone what is amiss? My guess is it has something to do with the ConferenceID Primary key being related from the Main to both the Day and Agenda tables, but I can't figure out if that's correct. Is there anything glaringly obvious why I'm getting the error?
Thank you!