Creating related records with server error

[rafs ome]

I've got myself in a muddle.. With two databases in a simple relationship. (story of my life ;-)

SAY: when I create a new record of a pupils attendance.

Pupil.fp5

global.fp5

attend.fp5 (with pupil joinID)

I have global fields (in a separate global.fp5) like times and dates, on a layout of the pupil.fp5 database. Then a script in attend.fp5 creates a new attendance record and copies the global details with the pupilID. And a portal on the pupil.fp5 layout shows the new addition.

I don't know if that's the best way of doing it? But it has created a problem. When several people are on the network (running off FMP server) people can't add data together because they get a 'ERROR -field in use by other person' I assume this is because of people trying to access the same global field?

better way? / ideas?

[rafs ome]

.