Automatically moving records to another table

[bethanw88]

Hi there, I am fairly new to access but have been charged with putting together acompany database.

At the moment I have tables for business enquiries that are in progress, and one for current contracts, and one for past contracts.

I would like a way of automatically moving a record from one to another as simply as possible. When I try and use append it does not seem to work. I can not just use a query for dates as there are other factors which keeps a record in each section.

Also the headings in each table are different, though I would like the information to be copied over when the fields are the same - or similar, i.e. what it appears you can do in the append to tool.

Any help would be greatly appreciated. I was hoping something like ticking a confirmed box etc could send it to current, and eg selecting a completed box could send it to previous - keeping the key information, but with additional and different fields also in the tables.

Any help would be greatly appreciated!

Thank you

 

[Beetle]

First, Welcome to the forum!

Next, the proper way to handle this would usually be to keep all contracts in one table, with a field to indicate if the contract is current or not. Without knowing whether a "business inquiry" has any similarity to a contract I can't say if it should be in a separate table or not.

Is there a reason you think that current and past contracts need to be in separate tables?

 

[Beetle]

BTW - I just noticed that this is a double posting. Please refrain from doing that.