Multiple Criteria

[wjm821]

First not sure if this would be done in a Form, Query or Table. My Table has Employee,Position and Pay. The Position has a drop down to check off what position. One employee could have 3 positions. When I add Pay it adds the amount to all the positions. How can I add pay for employee and the position. Example Employee Bill, Position Counter Pay $7.00, Position Repair $8.00, Position Tech $9.00

[June7]

If it 'adds the amount to all the positions', sounds like form and controls are not bound to correct fields.

If you want to provide db for analysis, follow instructions at bottom of my post.

Also, should not post multiple threads for same question. Pick one subforum and post only there.

[mike60smart]

Hi

First of all you need to think Normalisation of your Table.

An Employee can have Many Positions.

This means you need a table to record the Employees Details then a related table for Employees Positions.

[CJ_London]

suspect this needs three tables on the basis that a) the position 'sales person' could have more than one person, b) as already stated, the employee can have more than one position (at the same time?) and c) what about history? person A holds position X, then moves to position Y and person B moves to position X. Do you need to know who had what position when?

So I think you need employees, positions and a joining table for pay as a minimum