Simple Query - 09-07-2006 , 11:29 AM
I'm using a database based on the Contacts wizard. My query is about
the 'contact types' field. I need to be able to add more than one
contact type for each record - maybe three or four (because I'm listing
each contact's skills) - and I also need to able to search through
'contact types' taking into account all the categories.
I'd be happy with a number of dropdown boxes, or tickboxes - any ideas?
Re: Simple Query - 09-07-2006 , 12:35 PM
I would create a related table for the contacts, call it something like
tblContactTypes and include the contactID field (probably a Long, so it
can join to an autonumber) and a type (text probably that you get from
a combobox on your form) and the phone number field (text)
You would do essentially the same thing with Skills.
For this, I would stick to comboboxes.