Access: Populating Foreign Key with Primary Key using Forms

[lindsay99]

Hello,

I am creating a database for everyday use for my company. What I am struggling with is the following:

I have two tables. TABLE A: An AutoNumber is being used for the primary key. I created a form for this table so the information can be entered.

But for each record, there eventually will be an audit (TABLE B). I have a foreign key set up in TABLE 2 which is a number field. What I would like to happen is to create a command button from the form of TABLE A to open a form for TABLE B.

What I am having a problem with is getting my foreign key to populate with the AutoNumber of the primary key in TABLE A, thus always linking the two together.

Any sugggestions?

Thank you!!!

[MMcCarthy]

Hello,

I am creating a database for everyday use for my company. What I am struggling with is the following:

I have two tables. TABLE A: An AutoNumber is being used for the primary key. I created a form for this table so the information can be entered.

But for each record, there eventually will be an audit (TABLE B). I have a foreign key set up in TABLE 2 which is a number field. What I would like to happen is to create a command button from the form of TABLE A to open a form for TABLE B.

What I am having a problem with is getting my foreign key to populate with the AutoNumber of the primary key in TABLE A, thus always linking the two together.

Any sugggestions?

Thank you!!!

In the OnLoad Event of Table B's form put ...

Me.[ID Field] = Forms![FormA]![ID Field]

Mary