How to transfer data to another table when closed = yes.

[starclassic]

hello I have2 table tblClient(main) and tblActivity.
tblClient has the following fieldname.
PolicyNumber -> Primary Key
Name - Text
Closed - Y/N

tblActivity
ActivityID - Auto Number
PolicyNumber - Integral relationship to tblClient(main)
Comments - Memo
Paid - Currency.

Now how do I move this record to another table maybe (tblClient1) and tblActivity1 with same structure when close = Y.Then would delete this record from the source.

Any suggestion.

 

[dhookom]

Why would you want to move it when you have a field that identifies the status? This normally not good practice but may be justified in your situation.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]