cross refernce tables??

I have a staff table as so:

peter | 10.00
andy | 12.59
stuart | 10.00
matty | 12.00


I also have a mainstatic table which has static results for querying that has many columbs including a staff columb, only the staff name is inputed into the database so I need a way of querying the mainstatic getting the staff name, then getting the wage value from the staff table (shown above) and putting them in the main static... is this possible??

Although you haven't explained terribley clearly how your database works or whether you input the data in through a form or straight into a table. I believe you could either use a combo box or the DLookup function. If you are running a query to get a data set you can use an expression the includes the dlookup function to get the calculation.

An exmple is...

=DLookup("[Wages]", "staff table", "[Staffname] =" & forms!MainStaticform!StaffName)