Field in, how many tables?

Alkro

I'm sure this question is solved, but i don't find anything about it .

How can i know all tables that include the same field. For example, i want to change the length of a "No." field. But, i don't know if this field is in other table.

Is there any aplicattion to know it?

Best Regards.

Luc_VanDyck

You need the Developers Toolkit for that: Dynamics NAV Developer's Toolkit v2.0 SP3 (build 291)

Alkro

Thanks,

i have all tables, but too forms, codeunits...

Have i to change all C/AL Code where this field is named or only giving the correct lengt?

For example:

If a codeunit C/AL Code is like this:

Number := item."No.";

I have to change "Number" length to the same length... Is a hard job.

I've to change Description field length too. Double job?

ara3n

Yes, it's a lot of work and we do not recommend customers to do this kind of mod.

ivanlotter

The No. field can be in all your tables but are different. It is also usually your Primary key.

For example in the Job table No. will be the Job No in the Sales line table thus linking the two table.

modric

I've to change Description field length too. Double job?

If you intend to change Description lenght, read this:

http://www.mibuso.com/forum/viewtopic.php?t=19406

Its next to impossible to correctly change length of this field, although its really toooo short. But there are different methods of solving this, do some search in forum, this question is discussed here bazillion times already...

Savatage

Yes Bazillion covers it =D>
here's just 2 more of them
http://www.mibuso.com/forum/viewtopic.php?t=10402
http://www.mibuso.com/forum/viewtopic.php?t=14882

David_Cox

Never change the "No." field, it is passed into variables in functions of many many objects.

As said before "No." is used for all different tables, and is impossible to track.

If you gave us some more details of what you are trying to achive, we may have more ideas, many heads make light work, like adding a new field and just passing this where it is needed.

David