Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

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.
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page