Ray,
Something has happened with the two pages that we custom-configured to move records from our "active member" table to our "lapsed member" table. Once it was working, I don't recall doing anything more with these two forms. However, now what is happening is that when we call up an active member whose membership has lapsed, and we choose "No" in the Activity Status field, and fill in the Date and Year Removed (in the update_user form), and hit Submit, what's supposed to happen is that it moves that record over to our lapsed table. Instead, it is deleting the record completely. It no longer exists in either table.
I checked for a mismatch of data types in all fields (Date vs. Varchar) as well as "s" vs. "t" in the DW forms themselves and can find nothing. I'm attaching the two forms to see if you can spot something.
Gail