User Profile

Collapse

Profile Sidebar

Collapse
farahani
farahani
Last Activity: Aug 26 '16, 03:05 AM
Joined: Aug 23 '16
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • farahani
    replied to How to filter using combo box
    i've tried, not functioning.

    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,
    ...
    See more | Go to post

    Leave a comment:


  • farahani
    started a topic How to filter using combo box

    How to filter using combo box

    Can anyone help me to fix my filtering using combo box in the frmBookingFilte r. The selection of combo box must come from tblRoom. Need to filter all the information in tblBooking based on tblRoom.Room.

    i have 2 table
    1) tblRoom (Room ID, Room, Building, Level, Ext)
    2) tblBooking (Booking ID, BookingDate, Room, StartTime, EndTime, UserName, UserExt, Purpose, Chairman)

    In the tblRoom, the number of room...
    See more | Go to post
No activity results to display
Show More
Working...