Shanice asked:


I would like to link a field (primary key) of the parent table (1,2,3) to match the children in the child table. So if Joe Williams has two children, his unique id is 1 and then in the child table his first child is 1a and second child is 1b. The next parent would be 2 etc. And as I add new students can Access automatically link these fields to create the right ID?

I’ve tried everything…

THANK YOU!

New Cpr Guidelines

Share and Enjoy: These icons link to social bookmarking sites where readers can share and discover new web pages.
  • Digg
  • Bumpzee
  • del.icio.us
  • Facebook
  • Furl
  • Mixx
  • NewsVine
  • Reddit
  • StumbleUpon
  • YahooMyWeb
  • Google

  • Pulling Data From Multiple Tables Into a Single Query in Ms Access by Nicholas Brown
  • How can I create an Access report using 2 different tables as my data source?
  • How can I add columns from one table to another in Microsoft Access 2007?
  • How many different kinds of Periodic Tables are there?
  • C-arm Tables- Valuable Medical Imaging Devices
  • Table Tents Printing
  • Massage Tables Designed to Accommodate Various Massage Techniques
  • Comments

    ArmchairPilot on 18 June, 2010 at 2:13 am #

    The relationships view by birth order using the children to the parentno field called the two tables together in the rules.