2 ID's 1 Name

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Thanks for taking the time to read my question.

I have a product list that has an ID for every product. Each product has a
name and a size. I have a combo box on one form where size doesn't matter
(ha ha ha) but I need to limit the combo box list to only 1 of each product.
I need the ID as a hidden column so that I can stor it in the table.

ID Product Size
1 paint 1 Litre
2 paint 4 Litre
3 brush Small
4 brush Large

and so on...

I want my combo box to list:
paint
brush

I don't care what ID I store. How can I do this? If I group each ID is
displayed, If I choose First, I get the First ID, and only one record.

I need one of each product name, and any associated ID.

SQL:
SELECT tblMVUP.ID, tblMVUP.ChemicalName, tblMVUP.Active
FROM tblMVUP
GROUP BY tblMVUP.ID, tblMVUP.ChemicalName, tblMVUP.Active
HAVING (((tblMVUP.ChemicalName)<>"") AND ((tblMVUP.Active)=True))
ORDER BY tblMVUP.ChemicalName;



Thanks,

Brad
 
Try this --
SELECT tblMVUP.ChemicalName, First(tblMVUP.ID) AS SelectID
FROM tblMVUP
WHERE (((tblMVUP.Active)=-1))
GROUP BY tblMVUP.ChemicalName
HAVING (((tblMVUP.ChemicalName)<>""))
ORDER BY tblMVUP.ChemicalName;

I used a Yes/No field for tblMVUP.Active.

You would have column 2 as the bound column.
 
I'll add to make the size of the second column 0 in the properties of the
combo box if it is showing and you don't want to see the ID.
 
Back
Top