form question

[Guest]

I have created a form for users, there are several combo boxes for them to
choose information. I created different small tables (example of one:
Badges and the list includes Chief of Police, Assistant Chieft, Captain, etc)
and it assigns a # field for the primary key. I use this table in my combo
box as the data source, so the info is in the drop down. Problem, on my
table the infor is coming over as 1, 2, 3, (the primary field) and not the
infor from the drop down, then when I run the query I only get numbers
instead of infor. Can you have the infor from the form to come over to the
table?

 

[John Vinson]

I have created a form for users, there are several combo boxes for them to
choose information. I created different small tables (example of one:
Badges and the list includes Chief of Police, Assistant Chieft, Captain, etc)
and it assigns a # field for the primary key. I use this table in my combo
box as the data source, so the info is in the drop down. Problem, on my
table the infor is coming over as 1, 2, 3, (the primary field) and not the
infor from the drop down, then when I run the query I only get numbers
instead of infor. Can you have the infor from the form to come over to the
table?

You're misunderstanding how relational databases work.

Your table is NOT a presentation tool; ordinarily you won't be opening
the table and looking at it at all, instead using Forms and Reports
based on queries. Your table contains the numeric ID - and *that is
exactly what the table should contain*. You don't need to see it; it's
just the data repository.

If you want to see "Captain" on a Report, simply base that report on a
Query joining your table to the small tables. If you want to see
"Captain" on a Form, use a Combo Box with the ID as the zero-length
bound column, and the rank name as the first visible column. If you
want to see "Captain" in a table datasheet - you're misusing your
table datasheet!

John W. Vinson[MVP]