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

[weelco]

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

[Newsgroup_User]

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

[weelco]

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'?

[Newsgroup_User]

So you have one form that processes information for two tables, or do you
have two forms (one for each table - except the UUID)?

If it is one form just run two SQL insert statements. One for the primary
table, then one for the related table.
If it is two forms run the above two SQL statements then an update statement
to finish filling the second table.

Or am I completely misunderstanding the issue?

--
Bryan Ashcraft (remove brain to reply)
Web Application Developer
Wright Medical Technology, Inc.
------------------------------------------------------------------
Macromedia Certified Dreamweaver Developer
Adobe Community Expert (DW) :: http://www.adobe.com/communities/experts/


"weelco" <webforumsuser@macromedia.com> wrote in message
news:esjtjj$qtc$1@forums.macromedia.com...
> 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'?
>

[weelco]

Thanks the second option works like a charm!