Go Back   Access World Forums > Microsoft Access Discussion > Tables

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 04-22-2006, 06:04 PM   #1
seamusnboo
Registered User
 
Join Date: Jul 2004
Posts: 20
Thanks: 0
Thanked 0 Times in 0 Posts
seamusnboo is on a distinguished road
Multiple entries for the same field

I'm new to Access and databases so my question might seem dumb, but I need some help figuring something out.

Well, I have this database where I'm storing information from different charities. So I created a table with their name, address, phone, contact person, and many othe things. Now I need to create a field with the services that they offer. Each charity could be able to offer more than one type of service. So for the services field, I cannot create a drop down list because that only allows me to choose one service. So what would be the best way to allow the user select more than one kind of service offered from a list and then be able to search that with a query? I have a list with over 50 different possible offered services and each charity usually offers 2 or 3 different services.

Thanks


Last edited by seamusnboo; 04-22-2006 at 06:10 PM.
seamusnboo is offline   Reply With Quote
Old 04-23-2006, 05:43 AM   #2
statsman
Newly Registered User
 
statsman's Avatar
 
Join Date: Aug 2004
Location: Toronto ON
Posts: 2,074
Thanks: 4
Thanked 3 Times in 3 Posts
statsman will become famous soon enough
You could create a coding system with all of the individual services plus combinations.
OR
You could add new fields such as Service1, Service2 etc. up to as many as you need.
statsman is offline   Reply With Quote
Old 05-09-2006, 08:22 AM   #3
littlegod
Registered User
 
Join Date: May 2006
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
littlegod is on a distinguished road
I thought that junction tables are the answer to this.
in my db i have to combine teams with several consultants and even one consultant with several teams,i did all this with two tables, two fields each and one junction table with three fields.
Is this wrong or bad practice?

cheers,
dan

littlegod is offline   Reply With Quote
Old 05-10-2006, 12:22 AM   #4
neileg
AWF VIP
 
neileg's Avatar
 
Join Date: Dec 2002
Location: Newcastle, England
Posts: 5,975
Thanks: 0
Thanked 8 Times in 8 Posts
neileg has a spectacular aura about neileg has a spectacular aura about
Dan has the answer. You need three tables. You already have one for the charities. Your second table will contain the list of services. The third table will have a record for each service each charity offers. So if Charity A offers three services, this table will have three records linked to that charity and each record linked to the relevant service. The record in this table will hold the primary key of the charity and the primary key of the service.

__________________
You can't always get what you want, but if you try sometimes you may just get what you need - Rolling Stones

Cheers, Neil
neileg is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple sub entries for one field durbslaw Tables 1 08-24-2004 05:43 AM
concatenate multiple records into one text field database Forms 3 06-24-2004 11:05 AM
[SOLVED] Help me to count multiple field Naief Queries 2 06-22-2004 11:50 PM
changing multiple variable in one field to multiple varialbes lost81077 Macros 3 04-29-2002 12:01 PM
How do I get a field to remember previous entries? Rhythmdvl Forms 1 09-24-2001 11:33 AM




All times are GMT -8. The time now is 08:04 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World