Need help understanding/building form and subform

[jwleonard]

I need to build a form based on the following tables:
tblCourses
CourseID
Prefix (Part of composite PK) Text
Number (Part of compoite PK) Text
Title Text
Video Number
Media Text
Type
Length

tblUsers
UserID PK Autonumber
LastName
FirstName
Office
Phone
EmployeeNumber

tblSession
SessionID PK Autonumber
UserID FK to tblUsers

tblSessionDetails
SessionDetailID PK Autonumber
SessionID FK to tblSession
CourseID FK to tblCourses
DateBegin
TimeBegin
DateComplete

I'm sure I will aslo need at least on query to do this but I'm not sure what information to query for.

I need a form where a user can type or select their employee number and have it show their information to verify it.

Then their user id needs to go into tblSession in the UserID field with a new SessionID.

Then that session id needs to go into tblSessionDetails in the SessionID field and create a new SessionDetailsID.

Lastly the user needs to be able to select the course from comboboxes by title, type, or by cascading prefix/number, the course id for the selected course will need to go into tblSessionDetails in the CourseID field, but I want all of the info for that couse to show up in the form when they select a course. Also, they need to be able to select more than one course at a time. If I am understanding this right tblSessionDetails should show a line for each course selected but it will have the same session id!

The million dollar question; Is it possible to do this? I don't want someone to do this for me, I just need some help getting pointed in the right direction! Thanks again.