Job List with fields from different table

nverma · **Posted:** Thu Jul 12, 2012 3:56 pm

This might seem like a silly question: In the Job List (which is based on Job table), a user has requested that we should add two new columns (fields) from a different table (consumer table). Is this possible?

I tried to do this by changing the source: consumer."LHIN Code" and consumer."Age Today". But it doesnt seem to do anything. I am pretty sure it is possible. So what am I doing wrong??

Savatage · **Posted:** Thu Jul 12, 2012 4:32 pm

The info you need is in your last post:
viewtopic.php?f=23&t=53917

DenSter wrote:

nverma wrote:

i know the concept

By asking this question, you prove that you DON'T understand the concept.

You use GET to retrieve one and only one record from the database, for which you know all of the primary key values. If you don't know all of the primary key values, and you still use GET, you are using the wrong keyword.

DenSter wrote:

Just don't use it like that.

If you don't have all primary key values, you set filters and you use one of the FIND statements (FINDFIRST, FINDLAST, FINDSET) to retrieve the records.

Or via flowfield see vid:
http://www.youtube.com/watch?v=SFOVSGGGK0w&feature=plcp

Savatage wrote:

I'm sure I gave you these links before.

Add them to your favorites.
http://msdn.microsoft.com/en-us/library/dd301056.aspx
http://msdn.microsoft.com/en-us/library/dd355032

KYDutchie · **Posted:** Thu Jul 12, 2012 6:38 pm

Nverma,

I think it is very good that you want to learn NAV programming but please study the following books:

http://www.amazon.com/Microsoft-Dynamics-2009-Programming-Cookbook/dp/1849680949/ref=sr_1_1?ie=UTF8&qid=1342110400&sr=8-1&keywords=matt+traxinger
http://www.amazon.com/Microsoft-Dynamics-2009-Application-Design/dp/1849680965/ref=sr_1_1?s=books&ie=UTF8&qid=1342110711&sr=1-1&keywords=mark+brummel
http://www.amazon.com/Programming-Microsoft-Dynamics-NAV-2009/dp/1847196527/ref=sr_1_1?ie=UTF8&qid=1342110745&sr=8-1&keywords=david+studebaker

you will find these very interesting. I read and really liked all three of them.
I know that these books will show you how to program in NAV correctly.

Thanks,

Willy

nverma · **Posted:** Thu Jul 12, 2012 8:41 pm

I ordered two of the books and I will start going through them. $\:D/$

Thanks.

mibuso.com

Job List with fields from different table

Who is online