So confused. I own a small bed and breakfast in Panama. I want to enter all the data for all my past, present and future guests into a database, using a form. The form is now designed, more or less the way I want it. The form is called Guest List Form. This is my question. If I have a client, Joe Smith, and he stayed in say "Room A", I add his name and all his personal data to my list. When I plug in "Room A" I want all the pertinent information about room A to pop up, and where necessary, perform calculations. I have the following fields in the Guest List Table, for example (this is a simplified version)> Name Passport Number Room # (This is where I want the automatic stuff to start) Description (single, private, dorm) Bathroom (shared, private) Price (This is the calculated field) So, for example, if I put in Room A, I want it to show dorm, shared bath, $6.00 If I put in Room B I want to show private room, private bath, $20.00 Then, once the price pops in, I want all the tax and totals to be able to be calculated. Not knowing what is my best option, I also have another table created, called Room List, that has all these fields Room # (This is where I want the automatic stuff to start) Description (single, private, dorm) Bathroom (shared, private) Price (This is the calculated field) Using all of Access examples, I am trying to think of my rooms as products, for example, room C will always be a six room dorm bed, for $6.00 with a shared bath. Once you all tell me which is my better option, then I might need some help. I have been working on this for so long my head is spinning.