SourceTablePlacement in code...

rbaron71
rbaron71 Member Posts: 5
edited 2006-11-10 in NAV/Navision Classic Client
](*,)

I just can't find a solution for this...
What I'm trying to do is:
From the article-card I've created a button that runs a special search-form, from which the user can search among articles based on the article-
description.
In this form I create a filtered table showing all articles that have the
specified word in the description.The problem is that the first time You run
the form, the SourceTablePlacement (set to FIRST) selects the first record
in the list. If I then search for another word, the list is OK but the record
selected could be any of the listed records. How can I choose which
record is selected in a filtered list for example by using the
OnAfterValidate key for the textbox where the users write a word?

Best regards

Robert

Comments

  • Mbad
    Mbad Member Posts: 344
    Do you have a good reason for not using search description? It already has a key in the item table and if you just filter on it and use F5 lookup youll get your list.
  • rbaron71
    rbaron71 Member Posts: 5
    Hi,

    Yes, I do...
    The list that is presented for the user shouldn't only be filtered upon
    the decription, it's also sorted depending on the class (a new field that
    we have created in the Item table) and if the article is marked as a
    priority article (a boolean field created in the Item table).
    The list displayed is sorted with a key "Priority,Class,No".

Categories