Thanks for answer Ian! I need some more help I think because I'm a real newbie to this!
I tried the SQL command you gave me and it almost works. The problem is that when I insert a new record and choose an option in the menulist it comes back with another option from the list in the results page!?
I have 1 main table named "media" and 1 table named "mediatype".
In the main table I have a bunch of fields including INT primary key field plus an INT field named "MediaAccessLevelsID" as foreign key field. In the mediatypes table I have 2 fields, 1 INT field (primary key) named "MediaTypeID" and 1 VARCHAR named "MediaTypeName".
I tried to create a recordset named rsJoin and the following SQL command:
FROM media INNER JOIN mediatype ON mediatype.MediaTypeID = media.MediaID
What am I doing wrong?