How to insert a UUID into multiple tables in the same form

Forum|Forum|19 years ago
March 6, 2007
2 replies
760 views

I am trying to insert a UUID into 2 different tables at the same time ie to let this be created in the form and then insert this ID into 2 linked tables in a database using Access.
Does anybody have any suggestions on how to accomplish this?

Thanks very much

Advanced techniques

This topic has been closed for replies.

W

weelcoAuthor

Participant

Thanks the second option works like a charm!

N

Newsgroup_User

Inspiring

which part are you having trouble with: creating a UUID or inserting it
into 2 tables?

to create a UUID you can use a built-in #CreateUUID()# CF function;
if you set a value of a hidden form field to this, you can then insert
that field's value into your 2 tables... if you know how to, that is...

--

Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com

W

weelcoAuthor

Participant

Thanks for your quick reply, and yes I do know how to do that however I would like to do this all in one form field so I would like to create the UUID whith the same form that also submits it to another table, is this possible or do I have to do that using multiple 'pages'?

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded