Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Jan 2004
    Thanked 0 Times in 0 Posts

    auto populate tables

    I have table _Job, that gets populated when a new job is awarded. The fields are as follows:
    ID - Autonumber
    JobName - text
    JobNumber - number
    Locaton - text
    Mapsco - text
    PavDate - date/time
    SubDate - date/time
    Flatwork - date/time

    I have 5 other tables:

    Each of these tables has a 1 to many relationship to _Job.ID, using JobID as field name in each of these tables. My question is how can i get the field JobID populated with the ID from the _Job table as new jobs are added?


  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Crystal Beach, FL, Florida, USA
    Thanked 40 Times in 39 Posts
    If you do data entry into those other table via subforms on the form to which you entered your _Job record, you then set the Linking field properties: the Master property as ID and the Child property as JobID.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

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