Posting records to a join table

  • Thread starter Thread starter John Hawker
  • Start date Start date
J

John Hawker

I am developing a db to capture individual attendance at conference breakout
sessions. The problem is recording mutiple conferences, people, and topics at
the same time (i.e.; 1 employee record for each breakout session). I have the
following
tables: Employees, Events (conferences), Topics, and Attendance (join table
containing primary keys for Employees, Events, and Topics). I need to do
this with the least amount of data entry time possible.

I plan to use a main form to create the conference session with 2 independent
subforms for attendees (fixed membership list) and topics (list specific to
each conference). A command button, when clicked, would iterate through the 2
subform entries, creating individual records using
EventID/EmpployeeID/TopicID, and then post these to the Attendance join
table.

Q: How do you code the OnClick event? I do not understand DAO and ADO and
when to use each. Or even if this applies to this situation.

I would appreciate any help I can get.
John
 
I don't know much about your situation, but it would seem that the Employees
that attend an Event (conference) is a completely separate entity from the
Topics that were covered at that Event. You need two juction tables. One to
handle the relationship between Events and Employees, and another to
handle the relationship between Events and Topics.

Then, you would have a main form with two subforms (like you do now)
but you need to use the juntion tables as the recordsources for the
subforms. The Master/Child links will automatically handle entering the
EventID in the junction tables, then all you need to do is use a combo box
in the subforms for selecting the appropriate Employees and Topics.
 
OK. I think I see where this is going. But how can I accomplish this on a
mass production level? I have 125+ topics and 3000 members in a small
geographical area with no real way to break them up into smaller groups (they
travel a lot and pick the event closest to where they are at. How can I
populate the 2 subforms most efficiently?
 
With a combo box, as soon as the user begins typing the combo box
automaticalyy move to values that match what they are typing, so they
would never have to scroll through the entire list to find what they need.
 
Back
Top