Tabular-Type Form

mayer

Has anybody a hint for filter a „Tabular-Type Form“ which is filled only by the values of a table. The Filter should work like if Field 1 of the table has exact the same value of Field 2 it should not disappeare.

I tried it on trigger "OnNextRecord" but it won´t work.

Thanks.

Ralph

mfabian

There's no way to directly set a filter like in an sql statement "... where field1=field2".
In most cases it's very uncommon anyway that the same value is stored twice in the same record in different fields.
What you can do is inserting a new Boolean value which is set to true if both fields have the same value. The check should be done OnInsert and OnModify of the record. You can then use this Boolean to filter.

Marcus

---

Marcus Fabian
m.fabian@thenet.ch
+41 79 439 78 72

mayer

... thanks for help. The fields are (transleted from german) "delivered" and "delivered and payed". So the values are are the same when they are payed. Such fields shouldn´t displayed anymore if i want to see, which delivery isn´t payed.

greetings Ralph

(horrible english i know)

mfabian

Instead of using two boolean fields I would use a status option field with the three possible values:
ordered, delivered, delivered and paied

Marcus