Tabular-Type Form

mayer
mayer Member Posts: 50
edited 2001-02-20 in Navision Financials
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

Comments

  • mfabian
    mfabian Member Posts: 187
    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
    With best regards from Switzerland

    Marcus Fabian
  • mayer
    mayer Member Posts: 50
    ... 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
    mfabian Member Posts: 187
    Instead of using two boolean fields I would use a status option field with the three possible values:
    ordered, delivered, delivered and paied

    Marcus
    With best regards from Switzerland

    Marcus Fabian

Categories