Tables Link

[meddling]

I have 3 tables that I will use as forms. I wanted to display the main table including 2 buttons that would open the other 2 forms.
On Table 1 I have a EmployeeID field, set to Autonumber, Indexed (no duplicates).
One Table 2 (which would correspond to the first button) I have more information I want filed UNDER the EmployeeID in question. And on Table 3, there is more information that I also wanted filed under the EmployeeID in question.
Both table 2 and table 3 have an EmployeeID field as well, set to Number, not indexed.
So, when you press the button it would open up the records information that the main form is on.

Someone from here (M8KWR) told me to add this line (below) to the code. It does open up the forms when I click the button, but it does not save the information

stLinkCriteria = "[EmployeeID]=" & Me![EmployeeID]

No relationships between the tables have been done in the RElationship window as suggested by someone from here.

It was also suggested that I edit the default value of the Employee field related to the 2 buttons.
this is the expression given to me:

[forms]![Direct Deposit]![EMPLOYEEID] - Direct Deposit is the table in questions and EmployeeID is the field in questions.

Still does not work... Can anyone help?

 

[HitechUser]

PLEASE please do not open multiple posts for the same issuse. If you need to "raise" attention then respond to your post, that will bring it up to the "top"

Which one should we reply too????

This ??

http://www.tek-tips.com/viewthread.cfm?qid=993727&page=1

or this??

http://www.tek-tips.com/viewthread.cfm?qid=992438&page=1

or this?? Again???

http://www.tek-tips.com/viewthread.cfm?qid=993490&page=1

If you NEED to start a new post then reference the old one in it..
Thanks...