Martin Reid
mwp.reid at qub.ac.uk
Tue Aug 11 08:09:57 CDT 2009
Rocky Just trying that now Susan yip all this "quick" jobs turn out to be so much more (<: Martin 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 rockysmolin at bchacc.com [rockysmolin at bchacc.com] Sent: 11 August 2009 13:56 To: accessd at databaseadvisors.com Subject: Re: [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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com