[AccessD] Event Invites

Charlotte Foust cfoust at infostatsystems.com
Tue Aug 11 10:28:28 CDT 2009


Join table, Martin.  Or a self join, but that's messier.

Charlotte Foust 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Martin Reid
Sent: Tuesday, August 11, 2009 5:46 AM
To: Access Developers discussion and problem solving
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.





More information about the AccessD mailing list