Access 2002: Relationship problem/Database design problem HELP!!

[freebd99]

I have a problem that I'm not sure is a design issue or something else. I have a table: Trainings, under training I have the following fields day1, day2, day3. I would like the fields to contain title of certain programs offered, the programs are selected from a combo box from the electives table. The problem I'm having is that the value that is stored in the fields (day1,day2...) is the ID number for the elective rather than the title. I am also have trouble using referential integrity because I can only link the electiveID, to one of the choices in Trainings.
Example: electiveID -> day1 or day2 or day3. So if I update the elective title in the elective table it is not reflected in all choices.

I would greatly appreciate your suggestions/help.
Thanks
Anna

 

[Maquis]

I would change the layout of your training table to have 3 fields: Training Id, Day and Elective (plus any other applicable fields)
The day field would contain the day number and the elective field would contain the elective id.

Your relationship links should be a lot easier with this design.

Maq
<insert witty signature here>

 

[freebd99]

Thanks for your help.