Show actual name in table and not the ID Number.

T

TKM

How do I show the actual selection (data) in my table instaed of the ID
number associatied with the selection. I know there are ways but really need
help fast on this one.

Thanks again
 
C

Carl Rapson

TKM said:
How do I show the actual selection (data) in my table instaed of the ID
number associatied with the selection. I know there are ways but really
need
help fast on this one.

Thanks again
Click to expand...

I recommend against it. The ID number is what is stored in the table, so
that's what should show when you look at the table. Your users should never
edit data directly in a table. What you should do is create a form based on
the table, and bind a combo box to the ID number field. For the Row Source
property of the combo box, use a query that selects the ID number and
"actual data" from whatever reference table contains the ID numbers/data
pairs. Set the number of columns to 2, the bound column to 1, and the column
widths to something like 0";1".

Carl Rapson
 
F

Falty

I recommend against it. The ID number is what is stored in the table, so
that's what should show when you look at the table. Your users should never
edit data directly in a table. What you should do is create a form based on
the table, and bind a combo box to the ID number field. For the Row Source
property of the combo box, use a query that selects the ID number and
"actual data" from whatever reference table contains the ID numbers/data
pairs. Set the number of columns to 2, the bound column to 1, and the column
widths to something like 0";1".

Carl Rapson
Click to expand...
If you must do it on the table for the sake of speed use the same settings,
change number of columbs to 2 then change colum widths to 0:2

Falty
 
F

Falty

I recommend against it. The ID number is what is stored in the table, so
that's what should show when you look at the table. Your users should never
edit data directly in a table. What you should do is create a form based on
the table, and bind a combo box to the ID number field. For the Row Source
property of the combo box, use a query that selects the ID number and
"actual data" from whatever reference table contains the ID numbers/data
pairs. Set the number of columns to 2, the bound column to 1, and the column
widths to something like 0";1".

Carl Rapson
Click to expand...
If you must do it on the table for the sake of speed use the same settings,
change number of columbs to 2 then change colum widths to 0:2
 
T

TKM

NO I need the actual name the user selects to store in my table. None of
these work. Please help!
 
T

TKM

Falty,

What you provided me below send my users selection to the table and not the
ID? The users will never see the see the table however the boss wants it to
be universal thoughout the database until it changes.

Please advise
 
F

Falty

I'm not sure i understand what you mean, but simply changing the column
widths does not change the data the table stores, it will still store it by
the ID but you will only be able to see the name.
 
Top