Combo box and table question

[Kat]

Hi!

I have a combo box on a form where you can select a
problem from a list of five different problems. The
problem discription shows on the form which is want I
want. When I look at the table, the corresponding ID #
shows and not the description. How can I get both the ID #
and the description of the problem to appear in the table?

Any help would be greatly appreciated!

Kat

 

[Sandra Daigle]

Hi Kat,

Why do you want it in the table? Since your users shouldn't be looking
directly at the table anyway, you use queries to join the table with the
related table and include the description column from the related table.
This is a properly normalized scenario.

 

[Guest]

Thanks for your help Sandra!
It makes sense when I hear it that way!
Kat

-----Original Message-----
Hi Kat,

Why do you want it in the table? Since your users shouldn't be looking
directly at the table anyway, you use queries to join the table with the
related table and include the description column from the related table.
This is a properly normalized scenario.

--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.

Hi!

I have a combo box on a form where you can select a
problem from a list of five different problems. The
problem discription shows on the form which is want I
want. When I look at the table, the corresponding ID #
shows and not the description. How can I get both the ID #
and the description of the problem to appear in the table?

Any help would be greatly appreciated!

Kat

.

 

[Sandra Daigle]

Glad to hear it!

--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.

Thanks for your help Sandra!
It makes sense when I hear it that way!
Kat

-----Original Message-----
Hi Kat,

Why do you want it in the table? Since your users shouldn't be
looking directly at the table anyway, you use queries to join the
table with the related table and include the description column from
the related table. This is a properly normalized scenario.

--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.

Hi!

I have a combo box on a form where you can select a
problem from a list of five different problems. The
problem discription shows on the form which is want I
want. When I look at the table, the corresponding ID #
shows and not the description. How can I get both the ID #
and the description of the problem to appear in the table?

Any help would be greatly appreciated!

Kat

.