Welcome to SPN

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

Sign Up Now!

auto numbers to main reference number

Discussion in 'Information Technology' started by Adrian John, Jul 28, 2006.

  1. Adrian John

    Adrian John
    Expand Collapse
    Guest

    I am trying to develop a database that has one parent table to many children
    tables.The parent table uses a sequential ID number e.g starting at 1000 and
    child tables have their own 6 figure number based on name i.e Mary's numbers
    begin with 299 Jill's 101 and so on. How do I get Access to combine and
    select the next available 'empty' child number entry based on the childs name.

    e.g
    Parent 1000 Mary 299100
    Parent 1001 Mary 299101
    Parent 1002 Jill 101000
    Parent 1003 Mary 299102
    Parent 1004 Jill 101001

    Hope this makes some sense.
     
  2. Loading...

    Similar Threads Forum Date
    Opinion Is Autocomplete Evil? Some Women Take A Hard Look at Google ! Breaking News Nov 7, 2013
    Sikh News AutoZone sued for firing Everett Sikh Breaking News Sep 29, 2010
    India Singh: Centre Ready To Give Kashmir Autonomy Breaking News Aug 11, 2010
    India Paste tariff cards behind driver’s seat: Transport dept to automen Breaking News Jul 21, 2010
    Gursharan Kaur: India's First Lady's Autobiography Sikh Personalities Jun 1, 2010

  3. George Walsh

    George Walsh
    Expand Collapse
    Guest

    It is not necessary to control the numbers assigned to records. Just let
    autonumber work for each table and assign the key field a name that conveys
    the identity of the table - i.e., "Parent ID", "Mary ID", "Jill ID", etc.

    When each table has been created, create the relationship between tables in
    the relationship view, and relate each key field from the various child
    tables to a numeric field in the parent table that has the same name as the
    child's identity key field - i.e., "Mary ID", "Jill ID", etc.

    When records are added to the relational database an autogenerated number is
    added to each child key field as well as to the corresponding identity field
    in the parent table. It all happens automatically by one-to-many
    relationship you prescribe, and you don't have to control or even think
    about assigning records a number within a specific numeric range..

    Can this idea work for you?


    "Adrian John" <Adrian John@discussions.microsoft.com> wrote in message
    news:4ECB8558-CC32-4B9C-BEE6-198BD90F7A70@microsoft.com...
    >I am trying to develop a database that has one parent table to many
    >children
    > tables.The parent table uses a sequential ID number e.g starting at 1000
    > and
    > child tables have their own 6 figure number based on name i.e Mary's
    > numbers
    > begin with 299 Jill's 101 and so on. How do I get Access to combine and
    > select the next available 'empty' child number entry based on the childs
    > name.
    >
    > e.g
    > Parent 1000 Mary 299100
    > Parent 1001 Mary 299101
    > Parent 1002 Jill 101000
    > Parent 1003 Mary 299102
    > Parent 1004 Jill 101001
    >
    > Hope this makes some sense.
     

Share This Page