AccessAddict
Technical User
Hi
I have four tables related - tblRoomNo (1-M) to tblRoomTrack and tblAllDates (1-M) to tblRoomTrack (junction table)giving a M-M relationship between tblRoomNo and tblAllDates, and tblRoomType (1-M) to tblRoomNo. tblRoomTrack has two fields (Date and RoomNo), both set as PK's and keeps track of which room number is booked on any given date. When a user selects a room type and a date on a data entry form, I need to construct a query(ies) that will check for the combination of room numbers related to the room type selected and on the selected date, and if that combination already exists in tblRoomTrack then doesn't show the room number as available in another query that displays a list of available rooms. Sheesh, it sounds as complicated trying to explain it as it does trying to design it!!
I've run out of aspirin, got through a box of pencils and am now the proud owner of a mountain of scrap paper so am hoping someone here can help me!!
Thanks for your time
Alan
I have four tables related - tblRoomNo (1-M) to tblRoomTrack and tblAllDates (1-M) to tblRoomTrack (junction table)giving a M-M relationship between tblRoomNo and tblAllDates, and tblRoomType (1-M) to tblRoomNo. tblRoomTrack has two fields (Date and RoomNo), both set as PK's and keeps track of which room number is booked on any given date. When a user selects a room type and a date on a data entry form, I need to construct a query(ies) that will check for the combination of room numbers related to the room type selected and on the selected date, and if that combination already exists in tblRoomTrack then doesn't show the room number as available in another query that displays a list of available rooms. Sheesh, it sounds as complicated trying to explain it as it does trying to design it!!
I've run out of aspirin, got through a box of pencils and am now the proud owner of a mountain of scrap paper so am hoping someone here can help me!!
Thanks for your time
Alan