I have several data fields with for every data field a related notes field (both text). There is a layout with all the data fields with behind every field a button to the notes field.

Problem:

I do not want to make a new layout for every note field, but one general layout which shows (depending on the data field) the related note field.

My solution:

Behind every data field a button with a script which takes the notes field and puts it in a global field that's being displayed in the notes layout.

Problem 1:

I have to write another script for every data field that writes the data entered in the global field back to the correct notes field. Anybody knows an easier solution?

Problem 2:

What about security? Two people on the same time updating the global field for the same notes field. How do i secure this?

Thanks in advance,

Marten Hoekstra

Go relational !!

Create a Notes.fp5 file in which you'll create a record for each note you want to write

Relate the master file to Notes.fp5 using a unique field in the master file (usually a FM serial number); see related notes in a portal

You can also add a Type field in Notes.fp5 to mark notes related to one field or another

Problem 2

Global fields although global to the entire file, are in fact 'local' to the user that opens a multi user file. Each user therefore, can change their own globals without effecting others.