Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kenone
Starting Member
14 Posts |
 Posted - 2006-03-06 : 02:09:03
|
| I have a one to one relationship between two tables(members and pensioners) in SQL server with vb.net at the front end.The concept is when a member attains retirement age (60yrs) he should become inactive (but not deleted)in members table and his/her records should be automatically moved to the pensioners table so that to be accessed through pensioners form.I have an idea of creating a command button (on click event) using SQL statements to do this (though I dont know how)but any suggestions are highly welcome..... |
|
|
Kristen
Test
22859 Posts |
|
|
|
|
|
move records between tables -URGENT