Re: How to clear a field in a multiple table form?

Quoting Kim Tran... -> I have a form with 2 tables: -> - payment -> - partner -> -> Payment Screen -> -> Payment_EIN [f000] -> Partner TIN [f001] Partner Type [p1] -> -> Tables -> payment -> partner -> -> Attributes -> f000 = payment_table.EIN; -> f001 = partner_table.tin = payment_table.tin, queryclear; -> p1 = partner_table.type, queryclear; -> -> When I query and hit escape, all the values appear in the appropriate -> fields. But when I hit query again, the partner type field is not cleared -> although I use "queryclear" in the attribute section. I tried: before -> edit, before add, before query and after edit, after add, after query but -> it didn't work. Quoting from the SQL manual... "Use the QUERYCLEAR attribute to clear a joining field on the screen when you enter a Query operation." The reason QUERYCLEAR is not working on the Partner Type field is because it is not a joining field. As for the second problem about before/after query, this is why I prefer 4GL. Perform is limited to one active table at a time. If your current active table is the "payment_table", you can't do squat to the fields that are only in the "partner_table". DAS -- David A. Snyder @ Snide Inc. - Folcroft, PA Current Release is db4glgen-3.7 UUCP: ..!uunet!das13!dave INTERNET: dave.snyder@snide.com