Hi! I am creating a database to store research participant's session information. The basic design I came up with so far is:
Table1ppt info: participant (ppt) unique ID (not autonumber), ppt family doctor
Table2session info: ppt unique ID, session date, session staff, session number, scan...