Hi

How would I go about sending data inputted in a form to two independate tables?

A typical "form" would have a "submit" button. Does yours? If so, this could be easily scripted.

yes it does. How would you go about scripting this?

From a data design perspective, the data should not need to go to two different tables. The whole idea behind relational databases is to remove duplication of data...

The question can be interpreted in so many ways. Basically, any layout with a portal is a "form" that "sends" user input to two independent tables.

Setting aside questions of whether it's a good idea to do this, and with only a vague idea of your database structure... attach a script like this to your button:

Set Variable( $name ; name field )

Set Variable( $city ; city field )



Go to layout( "table A" )

Set Field( nameA; $name )

Set Field( cityA; $city )



Go to layout( "table B" )

Set Field( nameB; $name )

Set Field( cityB; $city )



Go to layout( original layout )