Using Collect Data with Related Tables

[JeffreyBee]

I am using Access 2007 & Outlook 2007
============================
Let's say I have two tables.

The first table is called Contacts that contains the following fields:
ID (Primary key - autonumber)
FName (text)
LName (text)
Newsletter (yes/no)
Email (text)

My contacts table is populated with 100 people and their corresponding
information.

The second table is called Survey and it contains the following fields:
SurveyID (primary key - autonumber)
ID (number - long integer)
Q1 (text)
Q2 (text)
Q3 (text)

Currently the Survey table has no records in it.

The two tables are related in a 1-many relationship using the ID field (from
tblcontacts to tblsurvey).

My goal is to use the Collect Data feature to send out a survey. In the
survey form I would like the recipient to be able to update their contact
information (if necessary) and to enter their survey responses.

I created a query using all fields from both tables. However no matter how
I set up my query when I use the Collect Data feature based on the query and
send out the email the form that goes out is blank (no contact information is
in the form).

Is there not a way to use the Collect Data feature with 2 related tables
that would allow someone to update current contact information and add a
related record in an underlying table that is empty?

 

[Jeff Boyce]

You may be trying to reinvent a wheel. Check out Duane H's AtYourSurvey
design for a different approach to surveys/survey data...

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[JeffreyBee]

No. I'm just trying to use a feature that Microsoft says should be available
to me.

 

[Jeff Boyce]

I'm referring to the structure of your 'survey' database...

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.