Creating an Active (y/n) Field on an Existing Table

You may want to mark certain fields inactive. For example, you may have clients that you no longer work with.

Go to the Clients table > click the Table Management sub-menu, or go to table management, find your table in the list and click edit. Add a column called "Active" and make the datatype a yes/no. Click "Add Column". (See Adding Columns).



Use the Form Designer to arrange the new field.



Update your clients and mark them Active yes or no. Grid Edit makes this faster.


You may also wish to Hide Inactive Fields from Drop-Downs