saving the product id not the product

  • Thread starter Thread starter Michael
  • Start date Start date
M

Michael

I have made a list box and every time i save the problem from the list, the
id is placed in the field in the table. I have tried changing the bound
column and when I do that .. I get a blank list. I have tried changing the
column count and get the same problem. The sql is as follows


SELECT Problemqty2.ProblemID, Problemqty2.Problem
FROM Problemqty2
ORDER BY Problemqty2.Problem;

I have deleted the id
SELECT Problemqty2.Problem
FROM Problemqty2
ORDER BY Problemqty2.Problem;
and I get the list in my sql statement, but the form is blank
thank you
Michael
 
What's the problem? The way it is working is correct. You should be saving
the product ID in your related tables, not the Product Name.
 
It actually is not the product name as I said, but a problem list and . it
is a combo box that sometimes the user puts in the problem manually. The
table is exported to be used directly by someone else and they need to see
what the problems are. I prefer not to have them have to look up the id. I
guess I could make a query that would make another column but I would just
like to save the problem as text. I have done it in the past and cannot
remember how.
thank you
Michael
 
Back
Top