[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