Update two tables with one form
Is it possible to update two tables from one form?
1. Ideally the one form might have to update behaviors attached to a single button.
2. Short of that two update forms on a single page.
Thanks
Nick
Is it possible to update two tables from one form?
1. Ideally the one form might have to update behaviors attached to a single button.
2. Short of that two update forms on a single page.
Thanks
Nick
yes, you can do this by applying two instances of the Update record behavior to the page.
Just make sure that the first instance is not set to redirect to another page, the redirect should only be performed in the second instance.
Problem with the second table updating.
I've zipped the file and the schema. The insert works fine but the update is not updating correctly, it's deleting the content and writing NULL! in the access_usr field. ther redirect is on the second form and it's working correctly.
your access55 form element is a part of another form
</form>
<form action="" method="post" name="Access5"><input name="access55" type="hidden" value="6" /></form>
since it is in another form, it is not posted when the main form posts.
change that code to:
<input name="access55" type="hidden" value="6" /></form>
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.