Hi there
I am learning (or trying to teach myself) Access.
I have come to a bit of a stumbling block. I have generated a dummy training company where trainers teach IT subjects. My 3 tables look like the following...
TrainersTable
(pk)TrainerID
TrainerName
Contact
Course Table
(pk)CourseID
Course Name
JunctionTable
LinkID
(fk)TrainerID
(fk)CourseID
etc etc.
The Junction table is there for a many to many relationship.
I have created a form which has a drop down list for the trainer and the course but at the moment, they are Unbound. How can I make them attach to the relevant fields in the Junction table?
Will I need a button to save the entry once I have selected a trainer and a course?
Can anyone give me a nudge in the right direction?
****BEGINNER WARNING****
Muchas Gracias people
Simon
Bookmarks