I need to do a quick and dirty proof of concept using Ms Access (Needs to be done yesterday!!!! ARRRGHH) on a clients network to show them how *EASY* it is.
The database design is done, no problems there at least in theory!
I have two tables:
The first, DETAILS_TBL: PID (The Primary Key), Name, Address and other personal details.
The second, QUALS_TBL: QID, qualification, date of qualification, PID (Foreign key going back to the first table, DETAILS_TBL).
I want two forms; the first for personal details, and second for qualifications.
I've linked from the first form to the second using the Form Wizard but the qualifications don't pick up the PID even though I've defined a realtionship between the two.
Can anyone with Access experience point me in the right direction?
I've tried messing around with the Datasource/Rowsource but to no avail!