Displaying a field with a number 1

[fiber0pti]

I have two tables. One table has a list of companies with a refernecing # to them. In the other table I have products with a column labled manufacter. I want to be able to store the # associated with the company in the products table. But when entering data I want to be able to see the Company Name.
Company Table Products Table
----------- -------------
22 Company 22

So I want the 22 in the products table to display the company name but store the actual 22.
How would I do this? I've tried many different queries so please don't ask me to post them.
Thanks

 

[ghubbell]

Hi fiberOpti!

Either in your products table or on your products form: you could make the control for your company# a combo box.

The Control Source for this combo is your company# in the products table. Make it a two column combo with a Row Source type: table/query, Row source: your company tables name. First column width 0. Second, what ever is appropriate (2~3"?). The bound column is # 1.

One little assumption here is that your company# in your company table is in the first column, and the name is in the second. If they are not you could either rearrange them if they are not already in use in their original order, or make a simple query based on the table, put them in the right order (I do this a lot 'cause you're guaranteed to set the names ascending or as you prefer), then base your combos Row Source off of this new query instead...

Should do it! Gord
ghubbell@total.net