Problems with tables and relationships

[spudracer]

I've got a table with all the people that work in my department's information.

What I want to do, is create a separate table that will track different things.

In the end, the main goal is to have it so when I click on a button on the main form to open this tracking sub-form, that it automatically pulls that person.

A little background, everyone has an ID that is an Autonumber. My whole problem is finding a way to create a relationship and enforce referential integrity.

Please help!

 

[spudracer]

Ok, well I solved that problem on my own, but now I have another question.

I want to have this separate table/form for tracking. I want to have a remarks sub-sub-form pop-up off the tracking form, with the information saved in the tracking table. So, for instance, I received a document today, so I would annotate that on the tracking form, then click the button for the remarks and enter some text in there, then close that form. It's all apart of the same table, just different forms.

Is it possible?