Results 1 to 2 of 2
  1. #1
    juli is offline Novice
    Windows Vista Access 2010 64bit
    Join Date
    Aug 2011
    Posts
    1

    Auto fill data (number) between tables

    Hello,
    I created a database to track a group of records (people). I couldn't figure out how to auto number the primary key to a random unique number that was less than 10 digits so I generated a list of random numbers and just use the next number off the list as I enter the next person which works OK- but I have to put that number on each table as the ID number to relate back to the Primary key and it seems that I should be able to have those auto fill with the entered number. Is it possible to have the number typed in "table 1" (people) primary key auto fill onto each of the other tables as an ID number??

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,597
    This number is the unique identifier for people table? The key will auto fill if forms/subforms are properly set up with Master/Child linking.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Auto Fill
    By Kerrydunk in forum Forms
    Replies: 16
    Last Post: 04-26-2011, 12:15 AM
  2. Auto-Fill one field, two tables, two forms
    By Swilliams987 in forum Forms
    Replies: 1
    Last Post: 01-21-2011, 12:43 PM
  3. Replies: 1
    Last Post: 12-09-2010, 08:29 AM
  4. Auto-Fill
    By sophiecormier in forum Programming
    Replies: 3
    Last Post: 10-02-2010, 08:29 AM
  5. Replies: 6
    Last Post: 04-14-2010, 11:03 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums