Results 1 to 3 of 3
  1. #1
    Join Date
    May 2013

    Unanswered: A Business and its competitors

    I am working with MS Access 2010.
    I am currently building a database that will store information on a Tourism buisiness. For example, a Hotel, Motel, bungalow, Tour etc...
    It has details such as, Owner, manager, type of accomodation, facilities it has, etcc...

    I also wanted to store information about the competitors of a particular tourism business, which will be another business stored inside the database.

    After analysing it. I found out that it will be impossible as it will duplicate my business table.

    Any ideas of how i can store the competitors?

  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    keep your exisiting design but include another column that indicates that if element its owned by you or a competitor
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    May 2013
    Thank you.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts