I have a database that tracks a candidate through a company’s recruitment process.
When the Candidate’s status is changed to ‘Contract Accepted’ I want them to appear on a ‘Master Staff List’. Once they are on that list there is a lot more data that will be added to the staff member’s record.
I’m unsure the best way to do this;
· a make table query doesn’t seem to do it as each time the query is being run it is creating the table from scratch and I would lose any other fields added to that table.
· an update query requires for the record to already be there; doesn’t it ??
· append query is creating duplicate records of staff members that have already been added to the Master Staff List
Any help would be greatly appreciated.
When the Candidate’s status is changed to ‘Contract Accepted’ I want them to appear on a ‘Master Staff List’. Once they are on that list there is a lot more data that will be added to the staff member’s record.
I’m unsure the best way to do this;
· a make table query doesn’t seem to do it as each time the query is being run it is creating the table from scratch and I would lose any other fields added to that table.
· an update query requires for the record to already be there; doesn’t it ??
· append query is creating duplicate records of staff members that have already been added to the Master Staff List
Any help would be greatly appreciated.