+ Reply to Thread
Results 1 to 3 of 3

Creating a lookup field in Microsoft Access issue

  1. #1
    Forum Contributor
    Join Date
    01-28-2014
    Location
    Manchester, UK
    MS-Off Ver
    Microsoft Office 365
    Posts
    127

    Creating a lookup field in Microsoft Access issue

    Afternoon all

    I am currently trying to create a lookup field in one of my tables.

    I have 2 tables "Packages" and "Products", I also have the fields "ProductID" and "ProductName" in both tables

    What i'm trying to do is when i select a "ProductID" from the drop down list in the "Packages" table i want the "ProductName" to auto populate with the data in the same field in the "Products" table.

    But when i'm trying to do this using the "lookup wizard" the "ProductName" field isn't in the available fields list.

    Does anyone know why this would be or how i can get around it?

    Thanks
    Dave

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019
    Posts
    15,054

    Re: Creating a lookup field in Microsoft Access issue

    You should be doing your lookups in a Form and not the table. Look at this link as to why....

    http://access.mvps.org/access/lookupfields.htm

    Here is a link on how to do a lookup in a form.

    https://support.office.com/en-us/art...8-3e391c42f239

  3. #3
    Forum Contributor
    Join Date
    01-28-2014
    Location
    Manchester, UK
    MS-Off Ver
    Microsoft Office 365
    Posts
    127

    Re: Creating a lookup field in Microsoft Access issue

    Quote Originally Posted by alansidman View Post
    You should be doing your lookups in a Form and not the table. Look at this link as to why....

    http://access.mvps.org/access/lookupfields.htm

    Here is a link on how to do a lookup in a form.

    https://support.office.com/en-us/art...8-3e391c42f239
    Thanks Alan!

    Cheers
    Dave

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1