HI THERE....I AM IN TROUBLE. I HAVE A TABLE WITH 8 COLUMNS. I MUST MAKE A FORM TO ADD RECORDS TO THIS TABLE. HERE´S WHAT GOES:

1 - 1 COLUMN NEEDS 1 REGISTER PER CLIENT, THE OTHER NEEDS 8, THE OTHER NEEDS MANY.

2 - THE FORM SHOULD ENABLE THE USER TO ADD INFORMATION IN ALL OF THE COLUMNS WITHOUT EXCHANGING FORMS.

3 - IN THE BOTTOM, I NEED THE FORM TO SHOW THE TOTALS FOR EACH COLUMN.



HOW CAN I DO THIS????

Are you talking about the basic add form?

You need to include all the fields that are defined within yoru .cfg file with the html_record_form. These can be either visible or as hidden fields but they must all be included.

You can setup your form to include statements such as complete the following fields if ......

You can set the format of the fields within your add form anyway you desire by changing the html coding. Then you also can define the final viewing layout in your columns.

I don't believe it is possible to show the totals within the add form. You would need to setup the calculations and have them display once the add form is submitted.

You will find information about doing the calculations in the FAQ noted below under the category "Calculations".

To help you setup your forms you can use JPDeni's configurator and then just modified the output provided. Visit her DBMan Tutorial at http://jpdeni.com/dbman/

Hope this helps

Unoffical DBMan FAQ
http://redundantcartridge.com/dbman/