Please tell us what the 15 tables represent and what columns are contained in
each table. You should design your database with the thought that someday
there maybe less or more that 15 assessment measures. You also need to ensure
that you do not have any redundant or duplicated data across your many tables.
Time spent in designing your database structure wil pay off many times in
the future.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".


"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!