foreign keys in ms access

[George Schneider]

I have an access database. The primary key in one table is set to autonumber
and links to a field in another table set to number (foreign key). My
question when i enter the information in table one shouldn't the value i
enter in the primary key field also populate the foreign key field of table
two? This is not happening? What could be the cuase of this if i enter data
into the table in datasheet view and the second table is not being populated.

 

[DL]

If the primary key is an autonumber field, then you shouldnt have edit
access to this field. It should be autopopulated when you add records in the
table containing this field.

 

[George Schneider]

whats weird is the foreign key in table two which is set to number which
links to the autonumber field in table 1 is not be populated with the
autonumber value from table 1.

 

[DL]

View the Relationship & referesional integrity

whats weird is the foreign key in table two which is set to number which
links to the autonumber field in table 1 is not be populated with the
autonumber value from table 1.