Parameter Query Help

[fireblade72]

Hi
I have a single table design database, capturing several email address for each organization. Is there a way that I can have a parameter query that lists all email address per group - without splitting the data into different tables?....I did think that I would need to set them up as a load of 1to1 tables??

My table design is this:
ID Network_Name EmailAddress_1 EmailAddress_2 EmailAddress_3 etc

I would like my query to ask the user what EmailAddress they want to return, so they choose "1" and then the results would be:
ID Network_Name EmailAddress_1
1 Bob bob@bob.com
2 Sid sid@sid.com

Hope that makes sense and any help would be great?!!

 

[boblarson]

My table design is this:
ID Network_Name EmailAddress_1 EmailAddress_2 EmailAddress_3 etc

I would have normalized this and had a table for email addresses. This would give the ability to have as many as necessary for anyone but also, if you had a YES/NO field for PRIMARY, you could quickly pull their primary email address.

So, it would be:

tblEmailAddresses
EmailAddressID - Autonumber (PK)
PersonID - Long Integer (FK from Persons table)
EmailAddress - Text (255)
Primary - Yes/No

 

[fireblade72]

Hi Thanks for this, but what about if I have 5 or 6 different email address for each organization and want to list of each - rather than just primary?

 

[boblarson]

Then you can - nothing to stop you. You might need to use a subform to display the many (email addresses) to the one (organization), but that isn't a problem. The problem is when you start using numbered fields - you limit yourself and the potential growth of your database because you should not have to ever add columns, but add rows. When designed properly your database should be flexible enough to handle change, but not require design changes (adding columns, etc).