The Original FileMaker Community
Business Templates - Demo Apps - Video Tutorials -Samples - Help - 46000 Member Forum

Our Preferred Cloud Hosting Provider

Pass Global Data In A FileMaker Relationship – FileMaker Today

Get real time updates directly on you device, subscribe now.

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..

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Accept Read More