I want to save a date to two tables. Here is my code for saving to the new table. It will be a new record in the members table and a replacement of the date in the contact table.

CASE m.paction = 'SAVE'
m.id = m.memid
INSERT INTO member FROM MEMVAR
set filter to alltrim(member.id) = alltrim(m.id)

I then want to replace the duesdate from the record saved in member to the duesdate in the contact table. How would I do that?

Thanks,
Tyler