1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Solved: Access 2007 Field Lookup

Discussion in 'Business Applications' started by ibanezsicko, Oct 11, 2010.

Thread Status:
Not open for further replies.
  1. ibanezsicko

    ibanezsicko Thread Starter

    Mar 19, 2010

    I have two tables and i want to lookup a value of one from the other.

    The first table contains a field called Department.
    The other field has Department ID and Description.

    I want to display the descriptions in the first tables Department field.

    I've tried the lookup wizard data type in design mode, but it just returns the Department ID's instead of the descriptions.


    problem was my logic. no worries.

    Any help appreciated.

  2. OBP


    Mar 8, 2005
    Lewis, it should only show the ID, as that is what it should store. Seeing the Description is what Forms are for, users should not really interact directly with tables.
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/955477

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice