I'm trying to populate fields in one table with data from another

say I have a table with employees in as follows

employeeID(primary key)
name
charge rate
trade

and say a table called labour

LabourID(primary key)
job record
name (selected on a lookup to the employee table)
charge rate (populated data from employee table once name had been
picked)
trade (populated data from employee table once name had been
picked)



Any help would be great



Mike