Data

[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..

 

[John Vinson]

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..

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.