Saving 1 field across 2 tables, is this possible?

Saving 1 field across 2 tables, is this possible?

am 21.11.2005 07:47:47 von 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. (I have this set up as a One-to-One Relationship at the
moment).
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

P.S. I posted this on another newsgroup and wa told it was the wrong one, so
if this is still the wrong one, can someone point me in the direction of the
correct one? thanks