Create a form with autolookup

[dah]

I have set up a database with participants and workshops. I need a form which will bring up all the participants info automatically along with a subform that lists all the workshops they have attended. I want to be able to type in the participants ID number, all their info comes up and then just add a new workshop to the subform.

The database is as follows:

tblParticipants
autoParticipantsKey = autonum PK
txtParticipantLastName = text
txtParticipantFirstName = text
txtParticipantStatus = text (using a lookup table)
txtParticipantDept = text (using a lookup table)

tblWorkshops
autoWorkshopKey = autonum PK
dtmWorkshopDate = date
txtWorkshopName = text
txtWorkshopSemester = text (fall, spring, ect.)

tblLinkWorkshopToParticipant
lngParticipantID = long int PK
lngWorkshopID = long int PK

There is a one-to-many relationship from each table to the Link table. I know I need to develop a query to use with the form so that the form can lookup the participant table. I'm just stuck at this point.

Thanks

 

[Pat Hartman]

Take a look at the example db I posted here:

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=40821&highlight=manytomany