Hi, I'm new to filemaker and am currently trying to create a pupil assessment database for the school I work at. The database consists of a pupil information table and about four other tables that contain all of the other assessment data.
This all works fine and dandy until I need to create a new record. Currently I have to go into each table add a new record and type in the pupil id. What I would really like to be able to do is create a new pupil record in the pupil information table and the other tables create a corresponding record automatically.
I have been messing around with the 'allow creation of records' tick box in the 'edit relationships' dialogue box, but I can't get it to create a new record - is there something I am missing? If anyone could shed any light on this I would be very grateful.
