making populated values into a lookup field:-(

[tatika]

hi:

I created a table called tblEquipment.
The fields are called "EquipmentID"(primary key & autonumber) and "EquipmentDescription"(which I populated w/their appropriate values).
My problem is that there are a few values that I would like to give the user the option to pick and choose what type of equipment they like. Ex: If I choose "Microphone" (EquipmentDescription), I would like the user to choose for a wired or wireless model.

Thanks in advance,

 

[lespaul]

do the users type the description of what they are looking for?

If so you would take that value and use it in the SQL:
SELECT * FROM TABLENAME WHERE FIELDNAME LIKE '*TEXT*'

which returns all the records that have TEXT anywhere in FIELDNAME

another option would be to have a combo box that shows the users all the EquipmentDesc and allow them to choose which one they want.

HTH


Leslie