dbTalk Databases Forums  

Simple Query

comp.databases.ms-access comp.databases.ms-access


Discuss Simple Query in the comp.databases.ms-access forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
justanotherdavemartin@gmail.com
 
Posts: n/a

Default Simple Query - 09-07-2006 , 11:29 AM






Hi

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?


Reply With Quote
  #2  
Old   
pietlinden@hotmail.com
 
Posts: n/a

Default 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.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.