- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Feb 04, 2020 05:57 PM
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!!!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Feb 04, 2020 11:13 PM
Hi Emily,
Is there any other data common between those records other than the name of the company? If not, then I see no better way than having 3 separate records. However, I would use the Group By to have those records in one easy to see view.
Best Regards,
Mo
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Feb 17, 2020 04:42 PM
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.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Feb 17, 2020 04:45 PM
OK…I guess that I can’t attach so I sent the screenshot to your email provided on the other post.
Thank you
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Feb 17, 2020 10:58 PM