Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Dependant tables

Discussion in 'Information Technology' started by Dire straits, Jul 28, 2006.

  1. Dire straits

    Dire straits
    Expand Collapse
    Guest

    Please help....
    I have created a databse with five tables (A,B,C,D and E). Table A is the
    Product Type list and Table B, C and D are tables containing differnt type of
    Products. Table E is the table that I want to store the transactions. Table
    E will be populated via a user form. The fields in Table E are Date, Product
    Type, Product and Quantity.
    In the user form is it possible to select Product Type (from Combo List of
    Table A) and that will only show the Products (from Table B,C and D). For
    eg. one of the product type is microphones and Table B is the list of all
    microphones. Is it possible, that when I select Microphone from the drop
    down menu then the Product list only shows me the list of the microphones.
    This is similar to the dependant list in Excel.
     
  2. Loading...

    Similar Threads Forum Date
    India 11 Constables Get Pregnant at Training School Breaking News Apr 26, 2011
    Warm Up with Winter Vegetables (Vegetarian Casseroles) Cooking & Recipies Feb 7, 2011
    India Two constables arrested for beating, extortion Breaking News Jul 27, 2010
    History Cleaning Out the Augean Stables Punjab, Punjabi, Punjabiyat Aug 25, 2009
    Sikh News Cold weather damages sugarcane, vegetables in Punjab (New Kerala) Breaking News Feb 1, 2008

  3. Tom Ellison

    Tom Ellison
    Expand Collapse
    Guest

    Dear Dire:

    I believe I see where you are making this most difficult for yourself.

    Having 3 tables (B, C, and D) for different types of products would be a
    mistake. Put them all in one table, adding a column that identifies the
    product type from Table A.

    You can easily create the appearance of splitting this into separate tables
    by filtering by the various product types.

    You may not need ProductType in table E, unless the product identifier is
    not unique without the product type.

    I can guarantee you things will go much better if you adopt this type of
    approach.

    You may want to keep the tables B, C, and D if they are useful in importing
    the data, but then process them into a single table with varying product
    types, and do all subsequent database work using this unified table.

    Tom Ellison


    "Dire straits" <Direstraits@discussions.microsoft.com> wrote in message
    news:F264455D-683B-40B7-8680-75143D78CA25@microsoft.com...
    > Please help....
    > I have created a databse with five tables (A,B,C,D and E). Table A is the
    > Product Type list and Table B, C and D are tables containing differnt type
    > of
    > Products. Table E is the table that I want to store the transactions.
    > Table
    > E will be populated via a user form. The fields in Table E are Date,
    > Product
    > Type, Product and Quantity.
    > In the user form is it possible to select Product Type (from Combo List of
    > Table A) and that will only show the Products (from Table B,C and D). For
    > eg. one of the product type is microphones and Table B is the list of all
    > microphones. Is it possible, that when I select Microphone from the drop
    > down menu then the Product list only shows me the list of the microphones.
    > This is similar to the dependant list in Excel.
     

Share This Page