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!