i have 2 table
1) tblRoom (RoomID, Room) PK:RoomID
2) tblBooking (Booking ID, BookingDate, RoomID, StartTime, EndTime, UserName, UserExt, Purpose, Chairman)PK:Boo kingID FK:RoomID
Using One-to-many relationship between two table RoomID-RoomID
Current Queries:
1) qryBookingList
Code:
SELECT tblBooking.BookingID, tblBooking.BookingDate, tblRoom.RoomID,
Leave a comment: