Welcome to SPN

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

Sign Up Now!

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

    Expand Collapse

    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

Share This Page