I have created a navigation form from two tables. The table names are Farm and Farmers. One farm can have many farmers. the pk of the farm table is contained in the farmers table as fk for the one to many relationship. When I enter data in the farm table the autonumber for the pk is generating but when i enter data in the farmers table the fk is not generating in the farmers table. What have I done incorrectly. Therefore I am concern that there is no link between the two tables in respect to data being entered.