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.

Hi,

Why not to handle creation of records in other tables through scripts.

When pupil record is created its ID can be grabbed and we can go to other table base layouts and create new records there. This all will be done in script and the user will not even know what is going on in the back process.

Pushkraj