Separating Active records from Inactive
New to this, and have a set of records with active and inactive members. I want to separate them (but keep them in in the same dB) so I can print the active records. There are category codes in a field from 100 to 800 for active people groups, and #999 for the inactive people. I'd like the #999 people to stay hidden. One more thing, if want to sort by name, or by orginization, the active and inactive all mix together because they are no longer sorted by category.
Use FM Pro 11 Thanks
Enter find mode.
Type 999 in the category code field
Click the omit button in the status area at the top of your screen
Perform the find.
You now have a found set of only active records which you can print.
The above process can also be scripted.