Creating Database problem

  • Thread starter Thread starter Bob
  • Start date Start date
B

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
 
Bob said:
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
Click to expand...

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
 
How do I write the code to populate the second field? any
help is appreciated in this matter Thanks
 
Back
Top