How to create an autogenerating number from the PK and populates the FK

N2IT

Basically I am creating a surrogate key on both tables one to many relationship. I have created the constraint from ID to ID one to many.

Autofill will put a number in the PK field but won't autofill the FK, which is giving me all sorts of fun.

Is there something simple I am missing like an easy work around or am I going to have to go to ole trusty VBA?

I'm thinking I am going to have to run a string in VBA that inserts into FK if PK has value.

Thoughts?

Btw I am in Access 2010

N2IT

Figured it out

How about changing the data type of the FK to number LMAO

Solved