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.
Person---<Skillset(PersonID, SkillID)>----Skills
Person---<PhoneInfo(PhoneNo,PhoneType,PersonID)
For this, I would stick to comboboxes. |