Enabling F3 to allow searching of data

david.weeksdavid.weeks Member Posts: 96
Hello All

I have recently placed the shipment no on the posted invoice screen and when the user clicks on the lookup key, the program goes to that shipment.

However, how do I allow the user to use F3 to search for shipments i.e. Bring up the Find box?

Thanks

Comments

  • jmjm Member Posts: 156
    Hello David,

    are you shure that you mean Navision.
    In Navision is F3 = Make a new Record.
    Why don't you use Strg-F/Ctrl-F on the "shipment no"-Control for Search.

    br
    Josef Metz
    br
    Josef Metz
  • david.weeksdavid.weeks Member Posts: 96
    Hi Josef

    Yes, sorry, I mean using the binoculars to search.
    When I press them, the find box does not appear and the find box does not appear when you press Cntrl/F.

    Is it the way I have created the text book and looup up?

    Thanks for your reply
  • jmjm Member Posts: 156
    Hi David,

    did you insert a that new field "shipment no" on the screen or in the table?
    if on the screen, hpw do you calculate that field?


    in order to help you, i need a little bit more and concrete information.

    br
    Josef Metz
    br
    Josef Metz
  • david.weeksdavid.weeks Member Posts: 96
    Hi Josef

    I placed the shipment no on the sales invoice header form.
    No new field was added to the sales invoice header table.
    The shipment no is retrieved via code I placed in the posted invoice form.

    Thanks

    David
  • jmjm Member Posts: 156
    Hi David,

    only on fields in the table you can use the search-function.

    are you aware the in one invoce there can be more than one shipment?

    if you need the search-function you must fill a field in the table.

    br
    Josef Metz
    br
    Josef Metz
  • DenSterDenSter Member Posts: 8,307
    Ctrl+F only works if you're on a field in the table. If the textbox is an individual textbox not linked to anything, then there is nothing to look up, so Navision won't show you anything to look up.

    Try entering a table relation into the text box, or creating a global variable Shipment (type rec - sales shipment header), assigning the textbox to the Shipment."No." field, enabling lookup, and programming the lookup into the OnLookup trigger of the textbox. You can also add a shipment field to the sales invoice header table and set a table relationship. That way you can just add the field to the form and lookup will work automatically.
Sign In or Register to comment.