Multiple tables in one form

CodeCharge Studio

Visual PHP Web Development

Visually Create Internationalized Web Applications, Web Reports, Calendars, and more.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> General/Other

Multiple tables in one form

Author

Message

DSawyerr

Posts: 4

Posted: 10/28/2008, 9:21 AM

Hi All,

Please help - I want to take some of the contents of several tables and display in a single form and then when I click on the submit button on the form put the output into another table for future reference. Basically I am trying to do a survey type analysis and put the output into another table.

Please let me know if there are examples I can look at.

I am using Mysql, PHP and javascript in the design.

Many many thanks.

mentecky

Posts: 321

Posted: 10/28/2008, 5:04 PM

Quote DSawyerr:
Hi All,

Please help - I want to take some of the contents of several tables and display in a single form and then when I click on the submit button on the form put the output into another table for future reference. Basically I am trying to do a survey type analysis and put the output into another table.

Please let me know if there are examples I can look at.

I am using Mysql, PHP and javascript in the design.

Many many thanks.

You can do what you want, but it's a little tricky. First, use the Record Builder to build your form. It will only let you choose one table, so pick the table with the most fields you wish to display. After selecting the fields to display you will see "Define Record options". Uncheck "Allow Update" and "Allow Delete". Finish the builder as normal.

Click on your new form and select "Data Source" in the properties explorer to open the Query Builder. Add any tables and joins that you need. You will have to manually add any fields you want to display to your form now.

Now the fun part... Click on your form again and set "Custom Insert Type" to "Table". Then click the button next to "Custom Insert" to open the builder. Select the table you wish to insert into and use the parameter list to tell it where to get the values for each field.

That should do it for you.

Rick
_________________
http://www.ccselite.com

These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Web Database

Join thousands of Web developers who build Web applications with minimal coding.
CodeCharge.com

Home | Search | Members | Register | Login