How do you search for a field in Dynamics NAV Table Designer?

So, how do you search for a field in table designer? Apparently, it is a feature that everybody is waiting for… but there is a trick that could help you!

Let’s find out (I need to find “Line Amount” field in table “Purchase Line”). If you would go to Object Designer and click on table “Purchase Line”. Then click “Design”.

In the table designer, click on a field name column.

Then, on your keyboard press the SHIFT button and hold it. While holding the SHIFT button, click on arrow-down button once or twice. You will notice, that lines will get selected (that’s what we are after).

Then (I hope you are still holding that SHIFT key button!), if you would click on the first letter of the field name, Navision will start searching for your field.

For my example, I am looking for “Line Amount”, so, if you would click on “L” a few times (while still holding down the SHIFT key), I will jump to “Line No” field – that’s not the one I need…

…so, Let’s click “L” again. And again, and again. “Line Discount Amount” – still not the one I need. Let’s click “L” again (still holding the SHIFT key). And here it is – “Line Amount” field.

I hope you will find this helpful. When I saw this for the first time, I could not believe I was using copy/paste table data to excel just to find a field…

If you have any questions, or suggestions, please leave a comment. Thank you!

Note: this does work with in variables and functions screens as well!

Technorati Tags: field, object designer, search, table designer