Sending data from one form to two tables

[zilly]

Hi

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

[Fitch]

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

[zilly]

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

[Vaughan]

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...

[comment]

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.

[Fitch]

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 )