Showing the ID in the form

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi,
I am making a form that is gathering data from multiple tables that have
relationships with each other. As you know, the relations are built on
primary keys (that are numbers) and then I have to show these numbers on the
form to be able to change the relationship. For my convenience, I am also
showing the description of the number (id) to make the things more readable.
This is making my form space doubled (since I have to put the ID and the
description on the form). Is there a way where I can see the description only
and change the description only, but actually it changes the underlying ID?

.

Relevant Pages

  • Re: IBM mainframe history, was Floating-point myths
    ... connected to a model 85 running MTMT (Rochester's home grown Multiple ... got them because a customer gave them back -- story involved threats of ... I don't think many were built. ...
    (comp.arch)
  • Re: NBC: My pet subject
    ... spent seven years buiding various exhibits ... STRUCTURES ARE BUILT. ... you can save what could become much worse damage. ... we're talking about multiple column and beam damage on multiple ...
    (rec.music.artists.springsteen)
  • Re: NBC: My pet subject
    ... It seems that you are assuming these structures are built like playing a game of "Jenga" - you can remove one little piece near the top, but because the pieces are all jig-jagged together the structure will hold. ... Usually, all you need is the time to fix it, and you can save what could become much worse damage. ... we're talking about multiple column and beam damage on multiple floors. ...
    (rec.music.artists.springsteen)
  • Re: Can Access database have secondary key?
    ... > By definition you cannot have multiple primary keys. ... > You can have a primary key that is composed of multiple fields. ... > To view/change index definitions for a table the easiest way is to open ...
    (microsoft.public.access.tablesdbdesign)
  • Re: FAX Program
    ... You can send multiple pages with XP's built in FAX. ... I see no advantage in a purchased program over the native XP ... can you fax more than one page other than the cover sheet? ...
    (microsoft.public.windowsxp.newusers)