Saving one field across 2 tables?

[Martin Howie]

Hi,
I've got an MS Access database with 2 tables set up. One is a personal
information table (tbBio) and the other contains information about their
role playing character (tbChar_Bio).
Because there are 2 tables, I have split the registration page into 2 pages
(newuser.asp and newuser2.asp) and am using 2 INSERT record funstions, one
on each page.
The problem I am having is that I am trying to find out if it is possible to
automatically fill in the Char_Name field in tbChar_Bio, from the Char_Name
field in tbBio.
Or another way to do it would be to pass the Char_Name data from newuser.asp
to newuser2.asp, but I am still unsure of how to do this.

I've been trying to keep the personal and RPG information separate for
security purposes, but feel that it will probably just be easier to have the
one table which holds all the information.

Any help is appreciated. If you need further information, please ask.

Regards,
Martin Howie

 

[Duane Hookom]

I expect you should be asking this question to an ASP news group. If
Access/JET supported triggers, it might be appropriate here.