Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Feb 2003
    Thanked 0 Times in 0 Posts

    creating unrelated tables in database (97)

    Would it be a bad thing to create tables that are unrelated and not going to be linked together in one database? Some tables relate to the same thing and will be linked like the one I had a question on earlier: Members and Programs. But I also have a couple other simple tables that keep track of things such as Flu Shots, Smoking Cessation program, etc. that won't be linked to the Members table but I thought it would be easier for the user to have all her tables in one place, not a bunch of separate little databases. Each table would have a query and an entry form and we would at the end of the year run a small report for each one. Thanks!

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: creating unrelated tables in database (97)

    No, there is no objection to doing that. The overhead of one table in a database is relatively large, so it is more efficient to keep several of them in one database (unless of course, you have other reasons to keep them apart.)

    I don't know if each of these tables requires a different structure. If they are mostly identical, you might consider putting these data in a single table with an extra identifier that could be used in queries to select a particular group of records from the table.

Posting Permissions

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