I have two table in access with the following fields:
HotelID and Location in table hotel and
HotelID and UserName in table user.
When I populate a cbouser with the username I need to populate cbolocation with the location. The table are related through Hotel.HotelID and user.HotelID. As I select a username in cboUser I need to see the related record in cbolocation.
Does anyone have any suggestions as to how to do this?