T
teacheyp
I am a new user to Access and I am hoping someone can help me. I have
created a database on research subject for a study. I have 14 tables in my
database that have all my subjects listed in them. The tables are set up by
the month the subject comes in for the tests. Since the subjects did not
start the study at the same time, I need all the subjects listed in all the
tables so we can know where they are in the study. Is there a way where I can
add a new subject to all my tables at the same time? I have a main table
that list all information about the subject and then the rest of the tables
are the different months that they came. In those tables are the tests they
took and their scores. Every table has one field that is the same, it is the
ID number assigned to each subject and it is the primary key in all tables.
created a database on research subject for a study. I have 14 tables in my
database that have all my subjects listed in them. The tables are set up by
the month the subject comes in for the tests. Since the subjects did not
start the study at the same time, I need all the subjects listed in all the
tables so we can know where they are in the study. Is there a way where I can
add a new subject to all my tables at the same time? I have a main table
that list all information about the subject and then the rest of the tables
are the different months that they came. In those tables are the tests they
took and their scores. Every table has one field that is the same, it is the
ID number assigned to each subject and it is the primary key in all tables.