2 ID's 1 Product Name

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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
.

Relevant Pages

  • 2 IDs 1 Name
    ... I don't care what ID I store. ... SQL: ... FROM tblMVUP ... Brad ...
    (microsoft.public.access.queries)
  • Re: Problems with querying date field
    ... >> If you want to put a database somewhere for safekeeping, ... database - SQL isn't about persistence, ... says nothing about the physical storage media to be used. ... store data on a tape, or a disk, or a CD, or a file, or any physical ...
    (microsoft.public.sqlserver.programming)
  • Re: Should I place a Domain controller in each of the 40 stores?
    ... They should be able to do that, one common way is to use a SQL account in an mixed SQL authentication enviroment where the Apps use a dedicated local SQL account to connect to the DB, but again the app may work differently. ... Also note that although it is possible, it's NOT recommended to cluster for example a SQL server that is also a DC. ... We plan to place a SQL server in each store as part of a new POS ... implementation and also migrate to XP Embedded for the POS terminals. ...
    (microsoft.public.windows.server.active_directory)
  • Re: Mail order for cameras
    ... >> Brad wrote: ... >> These kinds of posts amuse me. ... >> good store. ... > Reseller Ratings as it were some sort or oracle is pretty amusing too, ...
    (rec.photo.digital)
  • Re: Mail order for cameras
    ... > Brad wrote: ... > good store. ... Reseller Ratings as it were some sort or oracle is pretty amusing too, ... Club.com and even Dell and Ebay with good success. ...
    (rec.photo.digital)