>Thanks Cetin. That worked kind of. It temporarily replaces the date in the contact table. But when I exit the contact form the date doesn't stay in the contacts table. It stays in the member table but I need it to save to both tables. How do I do that? Here is the code:
>
>CASE m.paction = 'SAVE'
> m.id = m.memid
> INSERT INTO member FROM MEMVAR
> replace duesdate with contact.memdate in "contact"
> set filter to alltrim(member.id) = alltrim(m.id)
>
>
>Thanks,
>Tyler
Tyler,
I still cannot understand what the filter is for. IMHO you should avoid using filters as much as possible. Nearly always there is another better way to accomplish what's needed.
Contact seems to be buffered and no tableupdate occurred. Add a tableupdate() :
tableupdate(2,.f.,"contact") && Check help for parameter explanations
Cetin