What is the best way to store & retrieve simple text data between different shared (no server) filemaker files on different computers running at the same time & always across the board get or set the latest data.
Lets say I want to change a code across all applications at our business periodically throughout the day. I want to set that code anytime from any application that shares that same file, through any open file, using a script. And I want to be able to acquire the code via the same.
Global fields don't save till closing the file and the updated info won't be available until saving.
Global variables only work within the one file on one application.
Cartesian joins in every file work in principal but in practice seem to have record locking issues (see my other post)
Anything I am missing?.