Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Jan 2004
    Posts
    196
    Thanks
    1
    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:
    _CheckList
    _Factors
    _Flatwork
    _mixdesign
    _Supplier

    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?

    tables.PNG

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 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
  •