Hello :)
I am stressing out over trying to prevent doublebookings on my database which ive spent 2 days trying to figure out :(
so what ive tried to do is : use queries that will take one away from the other so that when i go onto my form which creates appointments it will do this:
Select Dentist ( via userID) and select the date after this the time field which is a combo box will only display the times that are available and will remove the times take.
Its been a really hard task for me and i am left with lots of queries due to trial and error but ive decided to turn for help as it is taking far too long that it should be :(
i have attached my queries to show what i have attempted. i would be greatful for any help :)
thank you
I am stressing out over trying to prevent doublebookings on my database which ive spent 2 days trying to figure out :(
so what ive tried to do is : use queries that will take one away from the other so that when i go onto my form which creates appointments it will do this:
Select Dentist ( via userID) and select the date after this the time field which is a combo box will only display the times that are available and will remove the times take.
Its been a really hard task for me and i am left with lots of queries due to trial and error but ive decided to turn for help as it is taking far too long that it should be :(
i have attached my queries to show what i have attempted. i would be greatful for any help :)
thank you
Double booking preventation
0 commentaires:
Enregistrer un commentaire