473,326 Members | 2,655 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

event/contacts/attendees

I've created a small database with the purpose of tracking events, who
is invited, who attends, and all related information.

I"ll try to explain here what I've done so far and where I need help.

Current Customers:
I have businesses, with a unique id and contact for the business with a
unique id. A business could be invited multiple times per event, but
separate contacts.

A business can be invited to several event, each time could be the same
contact, or different contacts invited.

The first thing I need to now is, how do I go about 'attaching' these
invitations to an Event?

The invitation list and all of it's information is pulled from DBSi and
I can import it into my database easily. I assume I need a
tblCustomers with keys being combination of customer and contact id #s,
I can then import the invitation list to that table.

If that combo person/business already exists, it won't add it again.

SO, now how do I 'attach' these to a specific event? Each event of
course has a unique id.

I will then have to somehow track 'responses', which could mean they
attended an event, responded to a mailer with a phone inquiry or
several other different things.

I'm just lost and need some direction..

I'm sure anyone willing to help will have questions.. feel free.. and
thanks in advance

Jul 17 '06 #1
3 1586
Based on what you describe, I think the relationships will look
something like this.

BUSINESS/CUSTOMER----(1,M)---CONTACT---(1,M?)---INVITATION(attendance
response)---(M,1)---EVENT

IOW,
Each Contact belongs to only one Business. Each Biz can have many
contacts. Each Contact can receive many invitations, but only one for
each event. (so EventID, ContactID combination is unique in
Invitation). There's only one response per invitation, right? If so,
you can put that in the invitation table. Otherwise, you'd need a
child table of Invitation (InvitationID as FK as minimum). Then you'd
have a table of events. If you can get multiple responses for an
invitation, your schema would be slightly different... the relationship
between Invitation and Response would be 1,M. At present, I have it as
inherently 1:1, because it's still in the Invitation table. Breaking
it out would yield this:

The only difference would be the PK for Invitation. If a contact can
have multiple invites per event, your PK is something other than the
(EventID, ContactID) combination, like an Autonumber. (Then that
record can have child records.) otherwise, your PK is (EventID,
ContactID).

I would test the design by creating some tables, adding a few sample
records, and writing some queries to test your design. Once you have
that, (ie. you get the info out that you need), build forms etc.

HTH,
Pieter

Jul 17 '06 #2
Ok.. I'm getting somewhere.. I just can't decide, where to record
responses to campaigns (i.e. event attendance)

Would I put a response Field in the table you refer to below as
invitation?

The table would have a customer id, contact id, event id and a response
field??

pi********@hotmail.com wrote:
Based on what you describe, I think the relationships will look
something like this.

BUSINESS/CUSTOMER----(1,M)---CONTACT---(1,M?)---INVITATION(attendance
response)---(M,1)---EVENT

IOW,
Each Contact belongs to only one Business. Each Biz can have many
contacts. Each Contact can receive many invitations, but only one for
each event. (so EventID, ContactID combination is unique in
Invitation). There's only one response per invitation, right? If so,
you can put that in the invitation table. Otherwise, you'd need a
child table of Invitation (InvitationID as FK as minimum). Then you'd
have a table of events. If you can get multiple responses for an
invitation, your schema would be slightly different... the relationship
between Invitation and Response would be 1,M. At present, I have it as
inherently 1:1, because it's still in the Invitation table. Breaking
it out would yield this:

The only difference would be the PK for Invitation. If a contact can
have multiple invites per event, your PK is something other than the
(EventID, ContactID) combination, like an Autonumber. (Then that
record can have child records.) otherwise, your PK is (EventID,
ContactID).

I would test the design by creating some tables, adding a few sample
records, and writing some queries to test your design. Once you have
that, (ie. you get the info out that you need), build forms etc.

HTH,
Pieter
Jul 18 '06 #3

te**@conwaycorp.net wrote:
Ok.. I'm getting somewhere.. I just can't decide, where to record
responses to campaigns (i.e. event attendance)

Would I put a response Field in the table you refer to below as
invitation?

The table would have a customer id, contact id, event id and a response
field??
It depends on whether you need to store multiple responses or not. If
you need to store one per letter or whatever, then store it in that
table. Otherwise, store it in the invitations table.

Jul 18 '06 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Fritz Switzer | last post by:
Can anyone provide a small snippet in C# that pulls out the Contacts in Outlook XP. I've seen a couple of examples in C++ and VB in previous newsgroup posts, but either the originals didn't work...
8
by: Ashish Shridharan | last post by:
Hi All I have been trying to add a control to the header cell of a datagrid on my ASP.NET page. These controls are defined in the HTML as ASP.NET web controls. They are being added into the...
1
by: Justin Koivisto | last post by:
I am trying to create a report that displays a name of an advertising source and count of the number of times it was hit between certain date ranges. The data is split between two different...
6
by: Shyguy | last post by:
I have a form where one of the entries is "Contact". On BeforeUpdate I check the table for the existance of that Contact. A mesage box informs the user that the name is already in the table and...
2
by: Dan Bass | last post by:
Environment C#, Asp.Net 2.0, Windows 2000 Server Problem I'm trying to enumerate all the names in the global contacts on the exchange server using CDO / ADO / (whatever I can). In writing an...
0
by: George Durzi | last post by:
Hey all, I finally found the necessary resources in the Exchange 2003 SDK to "pull" Contacts out of Exchange and display them on a WebForm. I have been trying to do this forever, and couldn't...
4
by: John Boy | last post by:
Hi, Can anyone help. This is really doing my nut in. 3 years ASP exp. and now doing .DOT which is a step in the wrong direction. Basically I am left with the code of a guy who has left. When I...
1
by: charliej2001 | last post by:
Hi all My access database has import/export capabiltiy of contact details between outlook. The database is getting big now (1000+ contacts) and so are the outlook address books that have the...
11
by: Bill Davy | last post by:
I am trying to edit Contacts in Outlook. This is so I can transfer numbers from my address book which is an Excel spreadsheet to my mobile phone. I came across the following snippet of code which...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.