Form/Subform help pleasee!(Next stage)

[Lakhvir]

Hello,

I have a booking form with the following fields:

BookingID
ClientID
StaffID
StartTime
EndTime
Date
TotalCost

In this form I have a sub-form with the following fields

AppointmentBookingID
BookingID
AppointmentType
CPH
SessionLength

The problem I am having is that when I want to make a booking how does the information get stored into the database As I'm selecting an appointment type from a drop down (it's a list of appointments e.g. divorce, litigation), how does this get stored in the tables. Because in the table in which I need it to be stored, it needs to be a number ID because it's a foreign key.

tblBookings has the following fields:

BookingID, ClientID, StaffID, StartTime, EndTime, Date, TotalCost

tblAppointmentBookings has the following fields:

AppointmentBookingID, BookingID, AppointmentTypeID, SessionLength

tblAppointmentTypes has the following fields:

AppointmentTypeID, AppointmentType, CPH

I hope this makes sense to you and that someone can please help me! Thank you very much!

 

[Lakhvir]

Anyone? Feel really upset and frustrated right now

 

[Shallo9]

Is your appointment_type a list item or stored in a seperate table..? However If you could upload your DB, we can look into it...Only to solve ASAP..However if it is in a seperate check what column is it bounded to...alternatively Dlookup function might be of some help....Good Luck

 

[Lakhvir]

Is your appointment_type a list item or stored in a seperate table..? However If you could upload your DB, we can look into it...Only to solve ASAP..However if it is in a seperate check what column is it bounded to...alternatively Dlookup function might be of some help....Good Luck

Hi, thank you for replying :]

On the subform the appointment type is a combo box which is getting the list of items from the tblAppointmentTypes. I have used a dlookup afterupdate on this combobox too, to get the cost per hour for each type. e.g. Select divorce from the drop down, and then the price comes up itself.

How do I upload a database onto here?

Thank you very much. I'm getting so mad here

 

[Lakhvir]

Really could do with some assistance guys Never thought forms were soo much hassle

 

[Shallo9]

Could you upload your DB to quickly have a look..

 

[Shallo9]

Really could do with some assistance guys Never thought forms were soo much hassle

When you reply you've got a little paper clip Icon on the format bar ...Use it to upload...however its a good Idea to zip it before uploading...

 

[Lakhvir]

Hii,

Kiwiman has managed to help me solve my problems I'd like to thank you for your willingness to help me. I wish my teachers were as helpful as all you guys!

This thread can be locked/deleted if needs be.