Thank You. This is very helpful and I now understand on how to do it but I would like to know what these tables are, where did they come from and what do they do to the actual database.
I have created 3 tables linked in a relationship, then I created a query to put all that data in a single table. The tables are called BookingTBL, Customers and PriceOfHotels. I have used the query to make a form the price of hotels table should not be updated but only viewed to retrieve...
I have two tables and one is for customers and the other is for prices of hotels. For every location, there is one hotel. In the customers form, I wold like it to auto select the hotel when the user selects a location. I would like to do this using relationships.