Creating Database problem

[Bob]

I am trying to create a database and use the primary key
from one table and feed that value into the Primary key
for another table is this possible? Or how can I feed an
autonumber primary key from a second table as a look up
into my first or primary table

 

[Arvin Meyer]

I am trying to create a database and use the primary key
from one table and feed that value into the Primary key
for another table is this possible? Or how can I feed an
autonumber primary key from a second table as a look up
into my first or primary table

The second table can use the first table's Primary Key (that's called a 1 to
1 relationship) but it cannot also be an autonumber. You'll either have to
write it in code, or create a 1 record subform.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

How do I write the code to populate the second field? any
help is appreciated in this matter Thanks