I have a database that I use to pay sporting officials.
I have a table for the official, a table for the match they work and for the
amount they are paid depending on which position the officiate. All are one
to many relationships.

What I want to do is have the input form calculate how much they are paid
based on the competition and the position they fill. For example a referee
makes $50 for a senior game, the two assistants each make $25.
The same official will make $40 for the next level down and the assistants
make $20.
I want to add the officials name in a field, the competition in another, the
position in a third and have the form autocomplete the amount to be paid. I
will use combo boxes with default values for all of the fields up to the
amount to be paid.

I've done this before but can't remember how.

Jack