Hello guys, I'm new 
I'm currently doing some coursework at school and have come across a problem. My system is basically an appointment booking system for a family law firm.
I have the main booking form with the following fields:
BookingID, ClientID, StartTime, EndTime, Date, TotalCost
In the subform, the fields should be:
AppointmentBookingID, BookingID, AppointmentType, CostPerHour, SessionLength
What I want is for them to fill in the main form, and then at the sub form they should be able to select the appointment type from a list and then the costperhour automatically gets filled in. How do I do this please? Normally, I'd make a combo box and then use the "find values lookup...", but it doesn't come up.
Can somebody please help me?
Thank you very much

I'm currently doing some coursework at school and have come across a problem. My system is basically an appointment booking system for a family law firm.
I have the main booking form with the following fields:
BookingID, ClientID, StartTime, EndTime, Date, TotalCost
In the subform, the fields should be:
AppointmentBookingID, BookingID, AppointmentType, CostPerHour, SessionLength
What I want is for them to fill in the main form, and then at the sub form they should be able to select the appointment type from a list and then the costperhour automatically gets filled in. How do I do this please? Normally, I'd make a combo box and then use the "find values lookup...", but it doesn't come up.
Can somebody please help me?
Thank you very much
