Making ID's into names

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to run a search for particular products in my database so that I can
keep track of how many adverts have been sold in a particular booklet. Fine,
I can do that, but all I end up with are columns of meaningless ID numbers.
Is there any way I can get Access to give names of companies and products
instead of just their ID's? I am using Access 2003.

Thanks for your help,

Carlos
 
I need to run a search for particular products in my database so that I can
keep track of how many adverts have been sold in a particular booklet. Fine,
I can do that, but all I end up with are columns of meaningless ID numbers.
Is there any way I can get Access to give names of companies and products
instead of just their ID's? I am using Access 2003.
Click to expand...

Certainly.

For starters - DON'T use table or query datasheets for viewing or
editing data. They are *very* limited.

Instead, create a Form based on your table. You can put a Combo Box
control on the form with its Bound Column being the ID from your
products table, and its Control Source being the meaningless ID
number; use the Column Widths property of the combo box to make the
width of the ID field 0. The second column of the combo would be the
product name. This way the computer sees the numeric ID, and the user
sees the product name and they both go away happy.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Thanks Duane, but the problem with doing it that way is the way my data base
is constructed. The orders are split between an Order table and Order
Details table. This is because we produce many different booklets and one
client may have more than one advert. I have a Client, Products, Orders and
Order Details tables. The Order Details table contains the information I
need, but only the ID's of the Products and Order tables. I would like also
to have the Client name, but that is only an ID in the Orer table. I just
have no idea how to get round this problem.

Thank you for you suggestion though.

Carlos
 
Back
Top