Hi…I am creating a base to manage groups coming to a hotel including blocks for bids, contracts, and invoicing. I am trying to figure out the best way to organize my table to have multiple room type data (room type, number of rooms, rate) for one group tour. Right now, I have 3 records duplicated where the only thing that is different are those three elements. That just seems inefficient. What are your suggestions on how to organize this information. Thank you!!!
Hi Mo…Thank you! Here is a screenshot. The only thing that is different between the 3 duplicated entries are the room type, # of rooms allocated, and the $. Everything else is the same. I was thinking that I could have a field with multiple entries but the rate and # of rooms allocated are specific to that room type so that wouldn’t work. If I could collapse the 3 so visually there was one entry, that would help as well. Thanks.