Very intersting Querry

ranjityadav

Hii all,

I want to know that,
is their any way to know Item no. feild is exists in which tables in Navision.

mohana_cse06

Export all objects in text format.
and search

chrispaul

Even that way you may not be able to find perhaps as it is a tedeous job first of all and secondly u never know about the naming structure of the customized objects.

AAshok

Hi,

Try to use the Where used functionality in Dev Toolkit
or use the Tables Object and Field

Thanks.

ssingla

Refer to the following link

http://mibuso.com/forum/viewtopic.php?f=23&t=29255&hilit=WHERE+USED

You will find lots of posts on this topic.
Search is your best friend.
Also use a better description in the subject.

kapamarou

You can also create a new form based on the Field table. Then filter on the field "RelationTableNo" using 27 (the item table...)

mohana_cse06

sorry..I didnt get u..Can u explain?

ranjityadav

Let me explain you guys wat i want

I want to search in all the tables in Navision for the feild name "Item No."

The outcome like all the tables name having the item no. feild.
Either through report or form.

mohana_cse06

did u try export thru text format.
u vl get all "Item No."
try once.

kapamarou

Kapamarou wrote:

You can also create a new form based on the Field table.

Navision has a table that stores all the fields of all the tables. It is table 2000000041 Field. You cannot see this in Object designer. You can assign it to a record variable or create a new form based on this.

Yo can create a new form on this table, add all the fields to the form (List form) and filter on any field. For example you can filter all the fields with name "Item No.", or all the fields with a table relation to Table Item.

This way you can see all the tables that relate to the Item."No." field.

Of course you will not see variables or forms that use this field, but you asked for tables.
For the best possible search use Developer's toolkit as advised above...

ranjityadav

there is no such table with ID 2000000041

kapamarou

kapamarou wrote:

You cannot see this in Object designer. You can assign it to a record variable or create a new form based on this.

It is a table like Date, Integer etc... It is a Virtual Table.

ranjityadav

yea i see it thanx dear

kapamarou

ranjityadav wrote:

yea i see it thanx dear

You're welcome. Take a brief look at all the tables at that range. They are very useful... Like the File table. Apply a filter to the "Path" field and you get the contents! =D>