automatic show up the value in the field

[Tom Nguyen]

I am trying to design a database that keeps track of the salary of my people
in my department. Because their hourly pay change when they reach their
promotion time. The pay is calculated: products X hourly. I would like to
design a table that it will show their hourly pay (update) in the appropriate
field whenever I enter their name. From that table, I will create the queries
that calculate income for them.for
Is this possible?

Thanks-
Tom

 

[Duane Hookom]

You haven't really said anything about your table structures so I can only
wag that you can create a combo box to select the employee. Make sure a
column in the combo box is the salary. Then in the after update of the combo
box, set your bound salary field in your form with code like:

Me.txtSalary = Me.cboEmployee.Column(2)