Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Jun 2010
    Location
    UK
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I am using maketables and append queries on a table with a lookup field. when viewing the table the correct display value is shown. However, when i run a maketable or append query the bound value is shown. I therefore need to link the source table in so as to get the display value.

    This is long winded and so I wondered if I am missing something? I cant change the source table as its accessed via Sharepoint and i dont have such rights.

    Rupert

  2. #2
    Star Lounger
    Join Date
    Dec 2009
    Location
    Bellevue, WA
    Posts
    61
    Thanks
    1
    Thanked 0 Times in 0 Posts
    One possibility is to join the "look-up" table and use the linked value to paste instead of the index of the linked value. In that way, you'll have the displayed value and not have to link to a sharepoint table.

  3. #3
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts
    Quote Originally Posted by rdsk View Post
    when viewing the table the correct display value is shown. However, when i run a maketable or append query the bound value is shown.
    I would use the exact opposite words to describe this situation. When you use lookup fields you ask Access to display the wrong value in the table. When you move the records to a new table (via append or make table) it shows the correct values. The true value stored in a table when you use a lookup is the value (usually a number) that links to the related table.

    Lookup fields are a ruse to show you something other than what is really there. It is common practice to do this with forms and reports, but when you do it with tables you are inviting problems, as you find. Another common problem is that query criteria don't seem to work, as the true underlying data in the table is not available to you.
    Regards
    John



  4. #4
    Star Lounger tgw7078's Avatar
    Join Date
    Jul 2010
    Location
    Seattle, WA., USA
    Posts
    90
    Thanks
    1
    Thanked 12 Times in 12 Posts
    > Lookup fields are a ruse to show you something other than what is really there.

    I agree (and so do many of my MVP friends). Have a look at the 2nd Commandment of Access, here:

    The Ten Commandments of Access
    http://www.mvps.org/access/tencommandments.htm


    Tom Wickerath
    Microsoft Access MVP
    https://mvp.support.microsoft.com/profile/Tom
    Tom Wickerath
    Microsoft Access MVP
    4/1/2006 - 3/31/2012

Posting Permissions

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