+ Reply to Thread
Results 1 to 3 of 3

Parent & Child Table Relations

  1. #1
    Registered User
    Join Date
    04-27-2017
    Location
    Masschusetts
    MS-Off Ver
    2010
    Posts
    73

    Parent & Child Table Relations

    Hi,
    Currently I have a parent table called "TBL_Admission_Data" with a unique ID being generated by MS Access. One of the fields in the parent table is called "Insurance Authorization #" and will be a 15 (or more) digit number. I've built a child table called "TBL_CONCURRENT_REVIEWS_Extensions". The two tables aren't connected yet but when they are, I would like the "Insurance Authorization #" entered in the parent table to become the unique ID for all the records in the child table. So I want what ever records are created in the parent table to automatically copy the Insurance Authorization # to the child table. Is this possible or will the child table need a separate unique ID#? Thank you for your help.
    Regards,
    Saabra

  2. #2
    Forum Expert Roel Jongman's Avatar
    Join Date
    03-28-2015
    Location
    Netherlands
    MS-Off Ver
    Office 365
    Posts
    1,482

    Re: Parent & Child Table Relations

    that should be possible, however, the max size of numbers is 15 positions so if the ID's are longer make sure they are text in both tables otherwise it will give problems in matching..

    Other than that it is not completly clear what you want.. do you want to copy the insurance autorization # regardless of there being any other information to put in the childtable?


    I'm sorry your question not regarding excel.. Please ignore my answer I did not notice this question was in the Access board.. I'm not 100% sure how to handle unique ID's in Access.. (too long ago)
    Last edited by Roel Jongman; 01-12-2020 at 02:44 PM.

  3. #3
    Registered User
    Join Date
    04-27-2017
    Location
    Masschusetts
    MS-Off Ver
    2010
    Posts
    73

    Re: Parent & Child Table Relations

    Damn, I was hoping you could turn this into child's play! Thanks anyway.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Parent Child relationship issue: Get parent ID for child
    By masterl1983 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-28-2018, 07:35 AM
  2. [SOLVED] Sorting with Parent and Child
    By dominict in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 06-04-2013, 06:56 AM
  3. [SOLVED] Parent child relationships(working out parent item) for each item
    By grphillips in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 03-21-2013, 05:58 AM
  4. Convert indentured parent child table to flat file
    By Liberator in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 02-12-2013, 11:29 PM
  5. Parent Child Relationship
    By Automation Guru in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-02-2013, 04:48 AM
  6. Parent Child Macro
    By ckattookaran in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-06-2012, 11:50 AM
  7. Sorting Parent Child
    By kcmtnbiker in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-30-2006, 09:00 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1