Results 1 to 2 of 2
  1. #1
    rici7 is offline Novice
    Windows XP Access 2007
    Join Date
    Oct 2010
    Posts
    6

    Vlookup function in access

    Hi,



    Im not very familiar with MS access. I have table with customers and orders. I want to fill automaticaly fields like Name, address, etc. when I fill customer number in form new order. In excel I use for this Vlook up function but I dont know how to do it in access.

    Can anybody help me please?

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    In Access the data should only exist in one table. To achieve what you are describing should be done by creating a query that joins the Order Table with the Customer Table on the CustomerID field and only the CustomerID is stored in the Order Table as a ForeignKey. Then your order form is bound to this query rather than the Order Table. You can display any field in any table on this form as it all of the fields were in one table. You will want to be changing the ForeignKey field in the Order Table and when you do the fields you display from the Customer table will change to the new Customer.

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

Similar Threads

  1. Query to work as a Vlookup function
    By dharmik in forum Queries
    Replies: 21
    Last Post: 01-04-2012, 08:12 AM
  2. excel function in access
    By lmp101010 in forum Queries
    Replies: 1
    Last Post: 08-03-2010, 05:02 PM
  3. Access equiv to the vLookup in a Query
    By Scorpio11 in forum Queries
    Replies: 10
    Last Post: 07-07-2010, 11:36 AM
  4. Load images in access using iif function?
    By sureshfina in forum Forms
    Replies: 1
    Last Post: 12-22-2009, 11:05 AM
  5. to_char function in Access?
    By Amber_1977 in forum Queries
    Replies: 0
    Last Post: 01-20-2009, 04:45 PM

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