Drop down list creating problems with data on table

  • Thread starter Thread starter Slapfish
  • Start date Start date
S

Slapfish

I think??? I'm not sure what the problem is. I created a
form with two drop down boxes to select customer names and
manufacturer names from other tables. It works perfectly
except that when I look at the table of data it shows the
data ID#'s instead of the actual names.

This is creating problems when I try to create a report or
query. What is the best way to correct this?
 
It works perfectly
except that when I look at the table of data it shows the
data ID#'s instead of the actual names.
Click to expand...

Of course. That's exactly what should be in the table. Storing the
names redundantly is neither necessary nor good design.
This is creating problems when I try to create a report or
query. What is the best way to correct this?
Click to expand...

Base the Report on a Query joining the data table to the names table.
Pull the names from the names table, where they belong!

This is exactly how relational databases are designed to work! Store
the data ONCE, and then use relational queries to associate the name
in one table with the data in another.
 
Thanks, I got it to work. The problem I had was the way I
was saving the data. I tried to do what you suggested, but
it wasn't working because the field I saved the name (ID#)
to was a text field and it wasn't compatible with the
Mfg.ID field on my other table. So I created a numerical
field for that data and linked it in a query and it worked
fine.

Sorry for the noobish questions. I used the program quite
a bit a few years ago, I even TAUGHT it to my co-workers,
but it's been a long time and I've forgotten almost
everything.


-----Original Message-----
 
Back
Top