Relating Tables

[AndrewPerl]

I am developing a database for our marketing department that helps them coordinate an executive retreat. I am using one table to store various information about an attendee and another table to store information about the various activities. I have built another table that would store the Attendee ID and Activity IDs to generate a list of activities for each attendee.

I have not been able to figure out how to make it easy for our amrketing folks to select the activities for each attendee on a form. Any ideas on this. I know this is not quite a VBA question. But any ideas would be really appreciated since I will have to work on this over the weekend if I can't figure it out today or tomorrow.

Thanks,

Andrew in KC

[boneKrusher]

post your DB and we'll look at it.

Bones

[AndrewPerl]

Here is some more information before I attach the database....

I have created an unbound form (Picker) that displays the name of the attendee and a list of events in combo boxes. I am able to get the ID records which I need to store in a table called "tbl_Scheduled_Events". There are only three fields in the table:

Schedule_ID (autonumber field also the primary key)
Attendee_ID (unique number for the attendee)
Activity_ID (unique number for an event)I need to write some VBA code that lets me insert a new record into the existing table. I already capture the Attendee and Activity IDs selected on the unbound form. How do I account for the autonumber field? I have not been able to get the SQL INSERT statement to add a record to my table.

Help!!!!

Andrew in KC

[boneKrusher]

its much easier if you post the dB, but here is a try.

If the employee is going to have many activities, then the emploeey table is the mother and the activities is the child. Basicly, a employee (1) to activities (many).

also make a table with all the activities. The combo box should list all the activities and the bound column of the combo box should drop into the control source in the activities table.

I hope that made sense.

Bones