put auto number in another table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two tables:

PatientInfo GeneticIDnum
-subjectnum (autonumber) - Subjectnumber
-and other patient info - geneticIDnum (random auto
number)

What I need to do is put the subjectnum value in PatientInfo table into the
GeneticIDnum table in the subjectnumber field.

How do I go about making this happen. Is there some VB code that I have to
use?
What kind of relationship do I need to make this happen.
 
If you use Form exclusively to enter Patient info then you can use code to
run an Append Query to add a Record in the Table GenericIDnum. You will
want to set the relationship between the 2 Tables as One-to-One.

However, I completely agree with John Vinson's advice in your previous
thread: there are better ways to secure your database.

Considering also that you will need to follow Douglas J. Steele advice
regarding how to generate a non-negative random number and to ensure that it
doesn't duplicate another existing number, I *think* you may be following
the incorrect path to achieve secuirty you want.
 
Back
Top