B
Bob Guidice
I'm trying to desing a database to track students at a school. One main
function that I'd like to have is this:
On the main data entry form, there will be subforms for attendance, test
scores, etc. I would like to be able to enter a Social Security Number, a
Last Name or a First Name at the top, and have the subforms populate with
the appropriate information.
Unfortunately, the problem I'm running into is because the Social Security
Number on the main form is the primary key, with which I'd like to enforce
referential integrity, I can only enter it once. Is there a way to get
around this, or is there another way to design this function in the
database.
I am pretty new to access, but once my tables are designed correctly, I'm ok
with queries and reports. I'm just having trouble with this function.
Thanks for any help,
Bob
function that I'd like to have is this:
On the main data entry form, there will be subforms for attendance, test
scores, etc. I would like to be able to enter a Social Security Number, a
Last Name or a First Name at the top, and have the subforms populate with
the appropriate information.
Unfortunately, the problem I'm running into is because the Social Security
Number on the main form is the primary key, with which I'd like to enforce
referential integrity, I can only enter it once. Is there a way to get
around this, or is there another way to design this function in the
database.
I am pretty new to access, but once my tables are designed correctly, I'm ok
with queries and reports. I'm just having trouble with this function.
Thanks for any help,
Bob