Allocating records

[scottemotive]

the mast table stores each and every record
the employee table holds all the employee names with related numbers for manager, department etc..
ive now added three more columns CallsRequiredPM (per month), and CallScreenedMTD (month to date) and FTPT which just says FT or PT

Basically each employee has to have 6 calls screened FT and 3 PT

i.e
Joe Bloggs, FT, callsrequiredPM 6, CallsScreenedMTD 0

what i need is that each time a record is added for an agent i want to keep a tally, i.e CallsScreenedMTD = CallsScreenedMTD +1 (this is to be reset to 0 at the very start of each month)

so in tblemployee this needs to be updated
how can i do this?

thank you

 

[ColinEssex]

I think you will find it easier to have the employee demographic detail in one table (with an AutoNumber as an IDNo) and the call data in a second table with the IDNo in that table as the Foreign Key, link the 2 in the relationships.

Then you can have a SubForm on the demographic detail form which gives the latest info on that employee.

There's no need to store the counts.

Col

 

[scottemotive]

Colin,

thanks i feared this
how would i structure this ive attached my FE for you to see my current structure