I want to show a list of records but limit it to only those where the user still needs to input data, if they have already input data for a record, then omit this record.
tblM - contains the data on various offices
tblD - contains the information for this month - ie. February 2006 is month 88
tblF - contains the figures / data
At the moment I am listing all the offices in tblM and the user inputs their monthly figures along side each office.
The problem is I am getting different people adding different figures for the same office and it is skewing my results...... ('replace into' isn't picking this up because of the differing user id's and differing figures)
I want to list only the offices where there are no figures for this month - if a user had already posted their figures, omit that office record from the list.
I can think of the code to list the offices where figures have been posted, but how do I turn this around and say forget those and give me the remaining ones?.......
