I am having trouble with a query. I have a set of serial #'s, which in a form associate with a name from another table. But in the query it won't associate with that name. I can eneter the data into a table with the serial# and the name showing but when I go back into the query, only the serial # shows and it makes a seperate entry without a name even though that number is already showing in the query. How can I fix this?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Query Trouble
- Thread starter bryand
- Start date
Databaseguy
MIS
Include the table with the name in your query and join the tables. te table wth the name must also have the serial number as one of it's fields.
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question
