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

Load defaults from one table to another

Discussion in 'Information Technology' started by wazza_c12@hotmail.com, Jul 28, 2006.

  1. wazza_c12@hotmail.com

    wazza_c12@hotmail.com
    Expand Collapse
    Guest

    HI All

    I have a curly problem here (I think)

    I have a database with a 3 tier issue code setup.

    Users can setup their own issue codes and descriptions, but I would
    also like to be able to offer a "load defaults" button option.

    Should be simple enough ..... howver my tables are as follows

    Lev 3 TB
    Lev3ID (PK/AN)
    Lev3 Code
    Lev3 Description
    Lev2ID (FK)

    Lev 2 TB
    Lev2ID (PK/AN)
    Lev2 Code
    Lev2 Description
    Lev1ID (FK)

    ....... and so on

    My foreign keys are PK auto numbers ...... so I cant take them from my
    "defaults" storage tables ... so after I load all my level 1 issues and
    codes, how can I know what foreign keys to load for the Lev 2 issues
    (and so on)

    Please help ... is this possible?
     
  2. Loading...

    Similar Threads Forum Date
    USA Are Turban-Wearing Sikhs TSA Targets? Sikh Coalition Uploads App Breaking News Nov 28, 2013
    Legal Protect Your Places of Worship (Download the US Government Guide) Breaking News Jul 8, 2013
    Download Kahn Singh Nabha's Mahan Kosh - English Translations Literature Jul 8, 2013
    Where to find Waheguru Simran album downloads? Questions and Answers Jul 7, 2012
    Sikh Books downloads Intellectual Translations by SPNers May 27, 2012

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