+ Reply to Thread
Results 1 to 2 of 2

Help Populating a Link (junction) table

  1. #1
    Forum Contributor
    Join Date
    07-31-2008
    Location
    Berkshire, UK
    MS-Off Ver
    2003 & 2007
    Posts
    118

    Help Populating a Link (junction) table

    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

  2. #2
    Forum Administrator ExlGuru's Avatar
    Join Date
    03-17-2009
    Location
    India
    MS-Off Ver
    2003,2007
    Posts
    222

    Re: Help Populating a Link (junction) table

    Get some information from this link:

    http://articles.techrepublic.com.com...1-5285168.html
    ExlGuru

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1