Connection with form and table

[rexie]

Hi all,

I am really very new to Access. Please help/suggest me after reading Below. Idonot want to use a Query but I would like to right a VB Function

I have a Form (Employee), would like to compute the Salary of the Employee based on three other tables.

Problem1
--------
1. How do the connection of tables(I have keys which can relate to each other)

2. When the user press a button in the form for that employee, the salary should compute only for that employee, if the employee doesnt have any record in the transaction file, then it should APPEND ELSE UPDATE

Please suggest a suitable solution

regards