Got a project to do for a University assignment but it is driving me crazy.
I'm doing a course booking database and I have a form where the user is asked to select a location to hold the course, then from that pick a room based on which location they choose.
I have the form working however I can't limit their choice of rooms to what location they have chosen, it simply shows all rooms, but gives an error if you pick a room which doesnt belong to that location.
Can anyone help :(
Thanks in advance
My Data is (from Room & Location):
Room ID (PK)
Location ID (PK)