P
pht1991
I need some advice on basic table set-up / linking
I have a student record table with a unique identifier (student ID)
Contains student name and address
I have an enrollment record table with the same unique identifier (student
ID) Contains term and year attended
Now I would like to create a third table to record transcript orders. The
unique identifier would be student ID. However, I would also like the
student name to appear in this table (it is stored in the student record
table). How do I get the name to show up in this new table without
duplicating the information?
I have a student record table with a unique identifier (student ID)
Contains student name and address
I have an enrollment record table with the same unique identifier (student
ID) Contains term and year attended
Now I would like to create a third table to record transcript orders. The
unique identifier would be student ID. However, I would also like the
student name to appear in this table (it is stored in the student record
table). How do I get the name to show up in this new table without
duplicating the information?