MySQL databases

[rmartinezg]

Hi everybody.
I'm just arriving to the landyard of this marvelous tool: simply amazing.
I hope we can stablish a rather mutual nutritive and satisfactory relationship in this, your forum. (and also that you can understand my rather spanish fashioned english!!)
Meanwile I have several concerns like.
- How can I know where are the forms I created stored at?
- Am I able to integrate those forms and database onto another application?
- How could I stablish relationships between database tables?
- Is it possible to generate multitable forms?

I am sure that any of those question have being asked before but I don't know how to find them out.

Thanks for any help

Ricardo

[ADaniel]

Hello Ricardo -

Have you installed FormTools and begun to use it ? The installation instructions in Documentation explain how to install it on a web server so that its form data will be linked to your MySQL database on that server. At that point, the form data is stored in tables inside the MySQL database you specified during installation.

Regarding integration of forms and the MySQL database into other applications, I often use Microsoft Access, installed on my clients' workstations, as an additional ODBC front end for the Form Tools MySQL form data, to quickly and easily generate user reports in a WYSIWIG environment, and to establish relationships between, and report on, Form Tools data and add that data to information gathered from other sources.

Regarding your question about multitable forms, by using the Hooks Manager (and lots of custom coding embedded there) with Form Tools internal forms, I can both pre-fill, and post-fill forms with data from other internal forms. So, in that way, yes it is possible to generate a multitable form -- meaning one form that pulls in data that has been entered in other forms, and that can even modify data entered in other forms. It does requires the use of both php and html, along with some skill in software and database design concepts, but it can be done.

There are many tips and solutions on this forum, but I have discovered it often takes reading through many posts to locate clues that lead me to answers , so be patient and search and read. I wish you happy researching !

[rmartinezg]

Hi Daniel.
Thank you for your time answering my post.

Yes. For sure: I strictly followed installation instructions and - as a matter of fact- I'm using FT directly from inside my hosting server area. The point is that I understand that relationing tables without the appropiate theorical base for normalized relationship (Date & Code dixit) is a very risky offer (I fugure down the madness of support people trying to explain why thing doesn't work with those tables the way they want, to users without that knoledge).

But I would feel served enough whether Form Tools let me design forms for handling data from my very own tables; wich I carefully designed and related. Do you think is this possible to achieve?

The next point is: where are those forms filed so I can move them to my website pages??

Please accept my apologies for such extense verbo. I appreciate very much your time and help.

Ricardo Martinez
rmg.ven@gmail.com