Data

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

Guest

I would like to know if there is a way to have the Primary
Key in table one "autonumber" be entered into the foriegn
Key in table two, without typing the number.

I'm trying to create a form that is one page and doesn't
require the enduser to enter the Foriegn key manually..
 
I would like to know if there is a way to have the Primary
Key in table one "autonumber" be entered into the foriegn
Key in table two, without typing the number.

I'm trying to create a form that is one page and doesn't
require the enduser to enter the Foriegn key manually..
Click to expand...

Use a Form for TableOne, with a Subform for TableTwo. Use the
autonumber field as the Master Link Field and the Long Integer foreign
key field in TableTwo as the Child Link Field.
 
Back
Top