Updating a table in Acess Automatically

[bigmike]

Hi,

I am wanting to make an asset management system to display PCs and their users.

The thing i am trying to do is:

When a user leaves, I want to be able to delete the user, then it will somehow automatically insert their PC (which is related to them) into another table called spare PC's

I havn't had much experience with access, especially in the last couple of years. I am running Access 2007

thanks

[Jim Doherty]

Hi,

I am wanting to make an asset management system to display PCs and their users.

The thing i am trying to do is:

When a user leaves, I want to be able to delete the user, then it will somehow automatically insert their PC (which is related to them) into another table called spare PC's

I havn't had much experience with access, especially in the last couple of years. I am running Access 2007

thanks

Just a suggestion...Yo u can do this Mike but why not simply have a field maybe a checkmark that denotes that the user has left. You can always raise a query then based on that field that determines who is active and who has left and retrieve PC's or other info via a query? Saves having to manage your synchronisation between two tables or am i off the mark according to the design?

Welcome to the Scripts!

Jim :)