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

    Automatic code assignment

    I am creating a form in MS ACCESS 2007 . i have a table like below

    CATEGORY CODE
    Electrical 0001
    Finishing 0002
    Sanitary & Plumbing 0003
    Structural 0004
    Mechanical 0005

    The need:
    Once the category name is selected from a combo box, the system should automatically put the corresponding code. Without typing it again.
    Thanks for your prompt assistance
    Kayode_ajayi

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    store those values in another table, and pick up that value from, say a list box. if you define the tables, then define the relationships the form designer will pull the realtionship in at design time
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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