Help with setting up a new part to the database?

[Adam7]

Hi,

In our main database there are thousands of people.

I need to have a new table that contains people that cannot go into the main database table until they have been phoned.

Then, if the phone call was successful they are to be added to the main table, if unsuccessful they are to be deleted or marked as delete so they are not contacted again.

The record also needs to be checked that it's not already on the main database at some point to avoid dupes.

Ideally, when a record is added to the main database, it is deleted from this new table.



Was hoping for some advice on the easiest way to move the relevant records into the main database without having to copy and paste each one individually.

My ability on access is limited and more so in the case of my colleagues, so it needs to be straightforward.

Every method I come up with seems to end up getting massively complicated so any suggestions would be much appreciated.

Sorry if this isn't very clear, I'm writing it in a rush!

Thanks,

Adam.

[pbaldy]

Well, it's not hard to move a record; you execute an append query and then a delete query using the key value of the record. That said, I would have all the data in one table, with an added status field. A status of "N" could mean needs to be called, a status of "D" could mean do not call, etc. That lets you get any or all status's easily using the appropriate criteria.