quick finding field

ajaybabuCh
ajaybabuCh Member Posts: 208
edited 2008-03-04 in NAV/Navision Classic Client
is there any way to find the required field quickly in a table having many number of fields.
Ajay

Comments

  • ara3n
    ara3n Member Posts: 9,258
    No there isn't. The only way I've learned them is through experience and using the software.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • kine
    kine Member Posts: 12,562
    Do you mean in designer or on form?
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • SteveO
    SteveO Member Posts: 164
    This tip has been a little helpful for me...
    • From Table Designer where you see the list of fields, put the focus on Field Name.
    • Press and Hold Shift and press down (so that you have highlighted two lines).
    • Press the first letter of the Field Name that you want to find (eg. B for Bank Account No.) it should then take you to the first Field that starts with that letter.

    Each search you have to highlight the next line and do the process again (although sometimes you get lucky and the FocusBox leaves the Field Name uneditable so you can just press the letter again and again without having to select lines to get it uneditable).

    Hopefully this helps you out a little :)
    This isn't a signature, I type this at the bottom of every message
  • ara3n
    ara3n Member Posts: 9,258
    I understood the question to be "What are mandatory fields that are required for a record" :-k
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • Waldo
    Waldo Member Posts: 3,412
    Copy to excel and find the field is "handy" when searching for one piece of the name (e.g. when many fields start with same letter(s)).

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • kriki
    kriki Member, Moderator Posts: 9,121
    Or make a form on table "Field" and run it and filter on the table you need. (No need to save the form).
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • Waldo
    Waldo Member Posts: 3,412
    This is starting to look like a "Tips & Tricks"-thread.
    :wink:

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • Mbad
    Mbad Member Posts: 344
    Thats amazing SteveO. Great trick.
  • Rko
    Rko Member Posts: 24
    Thats really cool, thanks
    Navision Developer and Consultant
  • ssingla
    ssingla Member Posts: 2,973
    From Table Designer where you see the list of fields, put the focus on Field Name.
    Press and Hold Shift and press down (so that you have highlighted two lines).
    Press the first letter of the Field Name that you want to find (eg. B for Bank Account No.) it should then take you to the first Field that starts with that letter.

    A another similar option. From Table Designer where you see the list of fields, put the focus on Field Name. Press Ctrl A that will select whole of the fields. Press the first letter of the Field Name that you want to find (eg. B for Bank Account No.) it should then take you to the first Field that starts with that letter. If you are not on the desired field repeat the process.
    The best part of this method is once you are done with the fields on the first screen i.e. the rows available on opening the form , you will not have to do CTRL A for going on another record. Just continue to press the first character of the field required and the select all will be automatically available.
    CA Sandeep Singla
    http://ssdynamics.co.in
  • kriki
    kriki Member, Moderator Posts: 9,121
    I just remembered:There is already a tip&trick like this : http://www.mibuso.com/forum/viewtopic.php?t=14005
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • Lin
    Lin Member Posts: 40
    SteveO wrote:


    From Table Designer where you see the list of fields, put the focus on Field Name.

    Press and Hold Shift and press down (so that you have highlighted two lines).

    Press the first letter of the Field Name that you want to find (eg. B for Bank Account No.) it should then take you to the first Field that starts with that letter.

    This is great, but...If you Press and Hold Shift and press down so that you highlight ALL lines and then Press CTRL (just once by itself) you can then continue hitting the first letter of a field (e.g. B for Bank Account No.) and it will take you through ALL fields begining with B (simular to Zoom)
    8)
  • toenne
    toenne Member Posts: 38
    but try the new download at mibuso:

    http://www.mibuso.com/dlinfo.asp?FileID=945

    if i'd only known earlier! O:)

    toenne

Categories