ICTkirsten
Registered User.
- Local time
- Today, 02:13
- Joined
- Jan 3, 2015
- Messages
- 137
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