[AccessD] Event Invites

Martin:

How about a second table with two fields - the Main Guest PK and the
associated guest PK?  Then you could use a simple query to draw the data
you need to push into Word from the Guest table.

Rocky


Original Message:
-----------------
From: Martin Reid mwp.reid at qub.ac.uk
Date: Tue, 11 Aug 2009 13:46:11 +0100
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Event Invites


The word part is Ok. I have that done for the main guest. In Access I need
to

Select the main guest.
Select their partners/s for the event

Create the Invite record containing

Main guest and multiple associated guests.

I need a simple way to associate the main guest with the additional guest/s
they would like to bring and then write this data back to a table. I then
use this data for the merge. 

So Main Guest A could also bring B and C

At the moment I am using a multi select list box to allow them to select
several main guests. This I think could be the problem. If they select
several main guests how do I then associate the additional guests?

Maritn



Martin WP Reid
Information Services
The Library at Queen's
Tel : 02890976174
Email : mwp.reid at qub.ac.uk
________________________________________
From: accessd-bounces at databaseadvisors.com
[accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
[ssharkins at gmail.com]
Sent: 11 August 2009 13:27
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Event Invites

> I am struggling with how to create the invite
>
> Once the invite is done I then create the invitations using Word
> templates. This bit is also done but at the moment only for the main
> guest.

=======It sounds to me like you're really just collecting information
right -- the "invite" is really just a collection of data that you then push
out to Word. Is this correct?

Susan H.

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


--------------------------------------------------------------------
mail2web.com – Enhanced email for the mobile individual based on Microsoft®
Exchange - http://link.mail2web.com/Personal/EnhancedEmail