Results 1 to 2 of 2

Thread: Vlookup function in access

  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 online now Administrator
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    10,757
    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.
    (RG for short) aka Allan Bunch MS Access MVP - WinXP Pro, Win7 Pro - acXP, ac07, ac10, ac13
    If your issue is resolved...go ahead and use the Thread Tools at the top of the thread and mark the thread as Solved!
    Teaching is not filling a bucket but lighting a fire.
    Borrowed quote..."Docendo discimus"

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, 06:12 AM
  2. excel function in access
    By lmp101010 in forum Queries
    Replies: 1
    Last Post: 08-03-2010, 04:02 PM
  3. Access equiv to the vLookup in a Query
    By Scorpio11 in forum Queries
    Replies: 10
    Last Post: 07-07-2010, 10:36 AM
  4. Load images in access using iif function?
    By sureshfina in forum Forms
    Replies: 1
    Last Post: 12-22-2009, 09:05 AM
  5. to_char function in Access?
    By Amber_1977 in forum Queries
    Replies: 0
    Last Post: 01-20-2009, 02: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
  •  
Tech Forums: Microsoft Office Forums