Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2011

    Unanswered: Multiple tables storing additional data in an shared table?


    I'm building an asset register database and have multiple asset tables (PCs, servers, Software, routers, etc) to store details of each item, however they all share some common fields such as supplier, date purchased, warrenty etc, so I thought it would be best to have a single table for those common fields and have each of the other tables linked to it. The relationships are one to one between each of the asset tables to the common fields table.

    However how do I ensure that each of the asset tables creates a new record in the common field table and doesn't edit a record that is linked to another record in one of the other asset tables? At the moment each asset table has link its record 1 to the shared fields table record 1, and 2 and so on.

    Do I have to use a create new record button on my form that create both a new record in the relevent asset table, and also goes and creates the next available record in the shared field table?

    There is a PK in the shared fields table that is linked to a number field in each of the asset tables.

    Thanks Anthony

  2. #2
    Join Date
    Mar 2009
    Provided Answers: 15
    This denotes a flawed conception of how you should organize the data. There a rules (called the Normal Forms) that precisely expose how data should be organized in a relational database. see (among many others):
    Database Tutorial
    A Simple Guide to Five Normal Forms in Relational Database Theory
    3 Normal Forms Database Tutorial
    Normalizing Your Database: First Normal Form (1NF)
    First Normal Form (1NF) - Normalising Your Database | Database Solutions for Microsoft Access |
    Have a nice day!

  3. #3
    Join Date
    Nov 2010
    In addition to what you said @Sinndho colleagues, I think your solution is the base model in the application of generalization and specialization. Rules

Posting Permissions

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