Need a bit of information

[Medic1]

So far I like what I see but I have a couple of questions before I upload the database and make the forms...

How do I join two tables? (Copy properties from? ) and will it fill in all the fields that are named the same?

Can a single field do a running total....example a member adds a mileage to a page. I need to have a total mileage from let's say 500 members but still have theirs as a stand alone also.

Can a member put in their email address and have a printable form come up with all their inputs from the entire year? (filters?)

Can I have an admin section where I can pull up everything for the year with all the information and can I have this password protected?

Im sorry for so many questions but I need some insight on this.

Thank You

Patrick

[xacto]

Hi -
This application PHP Form Magic does not appear to have all these features that I have noticed.
1) Table joins
2) Sum Columns
3) Custom script needed
4) Not from a form

Perhaps if you wish to use your form to store the data you may want to also look at the reports generator app to meet all you other wishes. It runs against a properly configured MySQL db. You can lock it down with directory permissions or .htaccess. Most all host offer this.

Cheers :cool:

[Medic1]

ok, Let me see if I understand (if you don't mind)

the report app will take care of some as I see from your reply,

it would also do a sum total???? but can I run a widget from it?

I also can't find where I join the tables at.

Thank you

[sarg]

but can I run a widget from it?That would be up to your coding skills. The script can be edited in any text editor.

I also can't find where I join the tables at.See this (http://www.websitedatabases.com/Report_Generator/related_tables.html).

[Medic1]

Thank you very much.

I will work on it