Hi all,
I have created a database for a friend and am now getting questions about building forms for it (I'm not very familiar with these). The goal is to enter Attendee information and allow the user to select a Course from each of four drop-down lists. My table structure uses an Attendees table(PK AttendeeID), a Courses table (PK CourseID) and a linking table called Attendee_Course.
I can create a form to enter the attendee information, but I can't find a good online resource to help me:
1) display the Courses.CourseDescription field in the drop-downs while setting the value to save to Courses.CourseID
2) save the Attendees.AttendeeID (I can use a hidden form field for this) and Courses.CourseID combination into the Attendee_Course table
Most of my knowledge is in SQL, but I can pick up on things pretty well if anyone can point me to an example of this kind of situation. Thanks!