How to create an autogenerating number from the PK and populates the FK
N2IT
Inactive Imported Users Posts: 7,483 ■■■■■■■■■■
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
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
Comments
-
N2IT
Inactive Imported Users Posts: 7,483 ■■■■■■■■■■
Figured it out
How about changing the data type of the FK to number
LMAO
Solved