need to get remaining records for dropdown

[benniesanders]

Greetings, I have a simple delivery calendar project. In Access 2000 there is a calendar table with a date and time field and a time table with 8 different time slots. The user adds a new calendar item by choosing a date then chooing an available time slot. Here's where I'm having problems. There are three entries for May 31, which means three time slots are filled. If someone tries to add a new calendar item, I would like the time slot select dropdown to only display the remaining time slots for that day. I absolutely cannot seem to make this happen. Any thoughts would be greatly appreciated. Thank you.

 

[monksnake]

Can you please post your query and your dropdown code so we can get more of an idea of your situation?

<.

 

[nicklieb]

something in the SQl statement to pull out those slots not filled.

eg.

Select slots from someTable where slot_booked=true

or it could the case where( i think this is probably what causing the headaches) is that you only record those slots from a list. And you want the remainder?

In this case, you would have the slots for each day, and then a list of the booked, you want a right Outer join to include null values, and then set you stmt to something like this

Select slots from someTable Right Outer join slots on slotid=sometable.slotID where booked is null

or something to that effect...

 

[benniesanders]

Thank you both. I'll try Nick's first, then repost either way. If it doesn't work, I'll post the code I have so far. Thanks again.