How to find fields in particular tables

Business Central/NAV User Forum
1

Various times I wasnt to write a new report and I want to Pick and choose what fields I use. i then have to search the various tables to see if the field I want is in the table. I want to use the fewest number of tables when i write a report. Is there any way to work backwards and find ALL of the tables a particular field is in?

Thanks

2

A lot of tables use the same field names. i.e. Document No., Line No., etc…

3

Maybe I should be clearer. Let’s say I am looking at the field “customer No.” Is there any way I can find every table that has the field “customer no.” in it?

thanks

4

Use Developer tool kit where used…

5

Unfortunately I am a user and do not have a developers license. I was hoping there was someway I could do this w/out the license.

6

Why would you need to know every table that has"customer no" on it.
Think about your report and what you are trying to accomplish.
you can also use GET and FIND to pull data from other tables as well as linking them in a report.

Can you give an example of a report you wanted to make and couldn’t find a field you needed?

7

wat is the use of simulate production order? can anyone explain briefly…

8

wat is the use of simulate production order? can anyone explain briefly…

[1] Why Simulation?

[2] The purpose?

[3] The benefit?

9

I am not familiar with GET and FIND. Can you lead me to information?

10

Get, Find & Next Functions

http://msdn.microsoft.com/en-us/library/dd338616.aspx

Introduction to C/AL

http://msdn.microsoft.com/en-us/library/dd338869.aspx

You can download the Application Designers Guide From Here: (w1w1adg.pdf) It has a section on Reports.

http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=24432

11

read the help documents…

12

I am newbie in this field. Google is your friend Go to google ask him. It gives you the best solution.

13

for every doubts or problems if help menu helps u then why we are here boss(blog)…if u don`t know the answer plssssssssss…

14

ya i understand your prblm but there is no option for find columners in NAV…

i`m also having the same problem if anyone hav sollution… pls help us…

15

Are you paying for our time and answers?

You have no rights to pass these kind of useless comments