Log in
Hot & Trending on FMT

Pass Global Data In A FileMaker Relationship

Data in global fields can be passed from one table to another and not have a relationship. So what does that mean, exactly? As you get deeper and deeper into your FileMaker solutions, you may begin to get a little overwhelmed. This is because a FileMaker database can hold a lot of tables and a lot of relationships. Many times, you need to have more than one table occurrence for each table.

However, you can pass data from one table to another using global fields and a script. Let’s say that you add some global field from another table on your layout. You can type data into those fields and the data will be in that table, no relationship required. Then you can run a script that goes to a layout using that remote table and that script creates a new record and sets the regular fields equal to their global counterparts.

I use this sometimes to log script activity. I can start each script with this global field data entry setup and never have to worry about a relationship problem.

By the way, this does not work with FileMaker Instant Web Publishing (IWP). At least, it did not work the last time that I tried to use this feature.
More info about the author and FileMaker in general, contact me at This email address is being protected from spambots. You need JavaScript enabled to view it..

Dwayne Wright

Dwayne Wright is quite simply put one of favorite authors. Dwanye has been around with us since the days of AOL. No matter what FileMaker subject you are looking for Dwayne has wriiten something on it.

Be sure and visit his blog listed below.

Website: www.dwaynewright.com/