|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
August 19th, 2008, 07:57 AM
|
|||
|
|||
|
General - Relationship/Table Help
I’m an Access beginner and having a little trouble setting up my relationships/tables. I have a huge list of contacts with email, their organization, as well as the events they attended. The goal is to see how many people attended each event, which organizations attended each event, and what events did each contact attend.
My problem is this, some of the contacts have attended more than one event and I’m not sure how I should be making my tables to reflect this. Additionally some contacts are from the same org. I created 3 tables (all duplicates removed): Contacts (first, last, email) Events (a,b,c) Organization (org name) I was going to attach the tables but did not see how to do so on a new thread. Any assistance is greatly appreciated. Thank you.
|
|
#2
August 19th, 2008, 08:35 AM
|
||||
|
||||
|
There is a fairly good explanation of how to set up such a Many-to-Many (M-M) relationship here
__________________
Wolffy ------------------------ Opinions expressed are my own and do not necessity reflect those of any sane person. Any code provided is intended to be an example and is provided AS IS. Rework for your specific environment may be required. Void where prohibited by law. Not valid in California. Your mileage may vary. Not FDIC insured
|
|
| Viewing: ASP Free Forums > Database > Microsoft Access Help > General - Relationship/Table Help |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
