×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Client/Entertainment Database

Client/Entertainment Database

Client/Entertainment Database

(OP)
Hi everyone

Just to let you know I only have Access 97 to play with and do not have access to the templates so i can't even play around with them.

I am trying to create a database which will have:
Client Name
Contact details within that client (could be more than one)
Functions that can be invited to
RSVPs to the functions

I have started this already with a one to many relationship and a contact table/sub form within the client table/form.

CLIENT TABLE FIELDS
ClientID
ClientName
StreetAddress
PostalAddress
suburb
Postcode
Phone
Fax
Email
Web


CONTACT TABLE FIELDS
ContactID
ClientID (link)
FirstName
LastName
Position
Phone
Fax
Email

We have a couple of functions through out the year which the contacts may or may not be invited to: Xmas Party and Golf Day.
Some of the contacts will be invited to both and others just to one.

We need to keep a track of RSVPs when they come in
i.e. if they have replied and whether or not they are coming
AND
if they haven't replied at all so this can be followed up.

If i create an Entertainment table with a list of all the functions. How and where do I link/add this table to the other information?

ENTERTAINMENT TABLE
EntertainmentID
TypeOfEntertainment

I thought about having an RSVP table
RSVPId
Yes
No
ContactID (link)

If there is not tick in either the yes or no, then it would be assumed that we have not had a reply. But again, how do i link with the contact info?

It is probably quite simple but i can't get my head around it.


thanks in advance for your help







 

RE: Client/Entertainment Database

I thought about having an RSVP table
RSVPId
Yes
No
ContactID (link)

I would change this to an ENTERTAINMENTinvite Table

ENTERTAINMENTinviteId
EntertainmentID
ContactID
RSVPed (Yes/no)
 

RE: Client/Entertainment Database

(OP)
Unfortunately i can't download the 97 template, for some reason my computer won't let me, so i have to do this on my own. I can't even find anything thru Google either :(

I have completed the company and the contact details tables with a head form and subform and that works beautifully even added a search.

CONTACT TABLE FIELDS
ContactID
ClientID (link)
FirstName
LastName
etc
Xmas Party-yes/no
golf day - yes/no

Now I have a FunctionTble and created a form based on this table and the subform to this will be a list of of all the contacts who have been invited to this event with their Company name.

FUNCTION TABLE
FunctionID
Type of Function
Function Date
Function Location
etc
contactID (link)

My RSVP table is
RVSPId
RSVP Rcd - yes/no
Accept - yes/no
Decline - yes/no
contactID

I have then combined the tables into a query called FunctionContactQry

CODE

SELECT ClientTble.CompanyName, ContactTble.FirstName, ContactTble.LastName, RSVPTble.RSVPRecd, RSVPTble.Accept, RSVPTble.Decline
FROM ClientTble INNER JOIN (ContactTble INNER JOIN RSVPTble ON ContactTble.ContactID = RSVPTble.ContactId) ON ClientTble.ClientID = ContactTble.ClientID;

This query then forms the subform for my Function Form.

So what i need is:
When I select the Type of function eg Xmas party on my FunctionForm, i want the subform to automatically pick out all the contacts who have the "yes" ticked in the contact table and populate the subform.

I so hope this all makes sense :)

thanks

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close