On Wed, 14 Apr 2010 10:24:08 -0700, marc
wrote:

I've created a database with about 15 tables for a participant data in a
research study. Each participant will complete the 15 assessment measures.

My ultimate goal is to create a data entry system whereby a research
assistant can pull up a form and enter an ID number, plus the answers to the
15 assessment measures.

I know I can create a query to combine all the tables, but it seems like the
research assistant would have to enter the id and date 15 times (once for
each table pulled in to the query).

Is there a way to just enter the ID number one time and have it apply to the
relevant tables? thanks so much!

You do not need fifteen tables. You need three.

The research assistant need not enter the ID number even ONCE - she never even
needs to *see* it, much less enter it! That's what combo boxes are for.

You will need a table of Participants; a table of AssessmentMeasures
(currently with 15 rows, you may want to add more later); and a table of
Answers, linked one to many to both of these.

For a fully worked out example of this kind of database, see
Duane Hookum's "At Your Survey":
http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='At%20Your%20Survey%2 02000'

or Roger Carlson's Training Registration database:
http://www.rogersaccesslibrary.com/d...gistration.mdb

--

John W. Vinson [MVP]