Form + Subform - MAJOR help needed! Going to fail all my work :(

[Lakhvir]

Hello guys, I'm new

I am currently doing an appointment booking system for a family law firm. I have constructed my tables and am now producing the main booking form and I am absolutely clueless. I know what I want to do but I just don't know how to do it and its making me really upset I'm actually feeling sick because I cannot do this and I cannot concentrate on other school work because of this

To start with and make this post more informative so that you guys can help me, I'll post my database structure:

CLIENTS [ClientID, Title, Forename, Surname, DOB, Gender, Address1, Address2, City, Postcode, Telephone, Mobile]


STAFF [StaffID, Title, Forename, Surname, Gender, Location, Department, Telephone, Mobile]
BOOKING [BookingID, ClientID, StaffID, StartTime, EndTime, Date, TotalCost]
APPOINTMENT TYPE [AppointmentTypeID, AppointmentType, CPH]
APPOINTMENT BOOKINGS [AppointmentBookingID, AppointmentTypeID, BookingID, SessionLength]


I want the main booking form to have the following fields:
BookingID
ClientID
StaffID
StartTime
EndTime
Date
TotalCost

On this main booking form I want a subform. The subform should contain the following fields:
AppointmentBookingID
BookingID
AppointmentType
CPH
SessionLength

I want the appointmenttype to be a drop down list, and then the cph automatically comes up. I think that the bookings are to be stored in tblBookings and tblAppointmentBookings. How would I do this then considering that they are selecting an appointmenttype and not an appointmentID?

Please please somebody help me ASAP. It's really making me sick I also apologize for this being such a long post, but it's better to not suffer in silence right?

[Lakhvir]

Anyone?