We've done enough database systems that it was obvious that alot of effort went into making "Maintenance Forms". What are they? Well, essentially they are usually pairs of forms for each table in your system.
For example, if you need to keep track of colours, you'd have one form called "Maintain Colours" that would show all the colours in your system, and another which would be called either "Add Colour" for creating a new colour or "Maintain Colour" for changing the details of a colour. So you would typically start "Maintain Colours" to show all the colours in your system, then you'd either click "Add" which would show you "Add Colour" or "Update" which would show you "Maintain Colour".
When you make complex systems, you usually need lots of these form pairs because you have lots of data to look after. For example, a trucking application might need to maintain lists of:
Tractors,
Trailers,
Drivers,
Trailer Types,
Suspension Types,
Customers and
Invoices
An Factory application might need to keep track of:
Materials,
Bills of Materials,
Materials Orders,
Materials StockTakes.
Sales Orders.
Products.
One of the joys of using SuiteMaker is that we make the forms automatically, meaning they are reliable and feature rich. If you want to sort by a particular column, just click it and it will sort... and you get that by default, along with a pretty report for that data that you can customize and print, plus the ability to select and copy out data for use in other programs.
