Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2013
    Posts
    1

    Unanswered: Auto lookup field data

    I am making a basic stock keeping database. My main table includes the part serial number and a description, and all but the last six figures of the serial number are the part number. If I have a separate table with the part number and description is it possible for the description to be automatically filled in when I enter a new serial number into the main table?

  2. #2
    Join Date
    Sep 2006
    Location
    Surrey, UK
    Posts
    995
    Provided Answers: 2
    Yes. Check the Help file for the DLookup function.
    10% of magic is knowing something that no-one else does. The rest is misdirection.

Posting Permissions

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