Basic Organization of Forms in an Application

Basic Organization of Forms in an Application

I could use a little feedback to help understand the basics of what elements one should typically expect to see after developing a well designed application in ZC. The question comes from trying to envision the concept that each form is itself a database, even if the sole purpose of some forms is to maintain another form.

For instance, as I understand it, if one was to create a database (form) of say something like �.

Item Master

�. it seems it would be typical to then create 3 different forms to maintain it, such as:

Item: Create/Add Record
Item: Update Record
Item: Delete Record.

With each of these 3 being a separate form, all of which operate on the form named Item Master, yet each acts in a different way, performs a different function and may only by accessible by specific users, depending on authority and/or job function.

If I understand it correctly, each one of the above forms itself is also a database. So, even though the main purpose of the application is to maintain the file called Item Master, in reality you would end up with probably 4 database files?

Item Master
Item: Create/Add Record
Item: Update Record
Item: Delete Record.

So, in the live environment, when a user was to use the form �Item: Update Record� (which contained a script to fetch and update) to change a record in the Item Master file, in addition to the change being made to the Item Master record, a separate record would also automatically be created in the file �Item: Update Record�? In other words, �Item: Update Record� would essentially contain a log history showing each update record action that was performed in the Item Master file.

I don�t know that I have a problem with any of this, I am just trying to make sure that I understand correctly that it is appropriate for me to end up with a number of by-product database files as a natural part of creating a system for maintaining the Item Master file.

As you can tell, I am totally new at this and am just trying to understand some basic concepts so I know I�m on the right track before getting too far on down the line.

Can any of you seasoned Zoho Creators provide a little illumination in this area?

Thanks much.