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

.

Relevant Pages

  • Re: Ms Access 2003
    ... employees to build a database application or use their department budget to ... I find that some businesses will pay, ... a small business which employs five consultants. ... when I was a corporate Access developer for a little more than a year. ...
    (comp.databases.ms-access)
  • Re: polymorphism (was: Poly Couples)
    ... but this is not really "business software"... ... Most of such applications are built as a combination of ... database with flat files or a different RDBMS vendor?" ... couldn't care less if I do it in using structured programming or OOP ...
    (comp.object)
  • Re: How should I generate a primary key?
    ... Obviously the designer did not get all of the business rules from the ... Should the database ... A Work Order records the transaction of a truck service at a given ... This has got nothing to do with bad design, it is about the developer trying ...
    (comp.databases)
  • RE: BCM for Outlook 2K3 vs Dynamics CRM SB edition (v.3) on SBS2K3
    ... with other users who are on different computers in BCM version 1.0. ... To share BCM database, you can refer to the following steps. ... you may refer to Business Contact Manager Help. ... Verify the connection between the Microsoft Firewall and the BCM ...
    (microsoft.public.windows.server.sbs)
  • Re: Data Layer architecture
    ... > the first week of>> any serious database course). ... rules were described to be inside the RDBMS, ... is not a theory which states anything about business ... > The Relational Model is nothing but a direct application of set theory ...
    (microsoft.public.dotnet.languages.csharp)