K
Kim
I have created a database in access 2002. I am familiar with flat databases
but when it comes to relationships it goes right over my head. I am trying
to organize a lot of people booking multiple hotels. Each hotel has multiple
categories and only so many rooms for each category. I had created a table
with the customers, then a table for each hotel and their categories. Then I
thought I would need a table for reservations to link both together but when
I tried the relationship thing nothing worked. I had added customer names
and added some hotels to test but I couldn't figure out what to next to get
the information added to each other. My ultimate goal is to connect
everything and then add a table to organize the rooming list when I get the
individuals names. I hope this makes sense to someone. If anyone has any
adive or samples I would really appreciate it
but when it comes to relationships it goes right over my head. I am trying
to organize a lot of people booking multiple hotels. Each hotel has multiple
categories and only so many rooms for each category. I had created a table
with the customers, then a table for each hotel and their categories. Then I
thought I would need a table for reservations to link both together but when
I tried the relationship thing nothing worked. I had added customer names
and added some hotels to test but I couldn't figure out what to next to get
the information added to each other. My ultimate goal is to connect
everything and then add a table to organize the rooming list when I get the
individuals names. I hope this makes sense to someone. If anyone has any
adive or samples I would really appreciate it