I'm using Mac FM Pro 12 on OSX Yosemite.
So I have an employment database and have my "active" "termed" or "pending" employees. All are currently visible in my current database, but I would prefer that only my "active" and "pending" data stay in the database I use each day. I have created a separate layout where I would like the "termed" folks to MOVE to, so they don't stay in my "active" (this is where everyone currently is) layout. Is there an easy script I can create to do this? I am seeing things with set Variable and I'm not overly familiar with how to make these work. I was hoping to do a find for "Termed" employees and then from there tell it to move those employees to the "Termed" layout. Is this doable? I apologize, I'm relatively new to FM. Thanks so much for your time.