I am having a problem with the relations between various fields in various tables. I have a table(A) with the field id which is linked to a field personId in table(B). When I create a record in table (A) i also want to create a related record in table(B) however, personId does not add a new record itself so I cannot create a record there. How should I go about fixing this problem?
Thanx

I would suggest you keep the same name for the Primary key and the Foreign key... You will need to create an append query if you want to add a record to the Many side of the relationship after you have created a new record in the One side. Normally you would not do it this way, but I don't know what you are trying to do so this is a solution.

hth,
Jack