drop down menu

[macca_mk4]

I have a database designed on court bookings in a racquet centre. On the court booking form i have a drop down menu of the courts and i want it so that when you click the "book" button at the bottom it removes the selected court from the list so you cant book it twice, any ideas?

 

[pyrohavoc]

do you have the list of available courts in a seperate table?

 

[macca_mk4]

urgent help needed please!!

 

[macca_mk4]

do you have msn or something so i can ask you coz im in work at 9 and i gotta show this in the morning at uni

 

[macca_mk4]

I have all the courts that appear in the box in a table called Courts which the combo box relates to.

 

[pyrohavoc]

welcome to my world ... been trying to get help since yesterday ... wish i could help you with the code ... i know what you need to do logically but i'm not real sure on the code ...

 

[macca_mk4]

damn, i got like till half 8 2nite and about an hour before i present it in the morning to get this done, this is the only part left i need to get working aswell!

 

[BenSteckler]

I know this is too late but does your court list need to have the entire permanently deleted, or just temporarily?