Jump to content

View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS

Tap the Share icon in Safari
Scroll the menu and tap Add to Home Screen.
Tap Add in the top-right corner.

To install this app on Android

Tap the 3-dot menu (⋮) in the top-right corner of the browser.
Tap Add to Home screen or Install app.
Confirm by tapping Install.

FMForums.com

Sign In

Email Address

Password

Remember me
Not recommended on shared computers

Forgot your password?

Or sign in with...
Sign Up

Creating related records with server error

Followers

December 2, 200322 yr

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?