mibuso.com

Microsoft Business Solutions online community
It is currently Wed May 22, 2013 3:11 am

All times are UTC + 1 hour [ DST ]




Post new topic Reply to topic  [ 4 posts ] 
Author Message
 Post subject: Job List with fields from different table
PostPosted: Thu Jul 12, 2012 3:56 pm 
Offline

Joined: Fri Sep 30, 2011 7:04 pm
Posts: 298
Country: Canada (ca)
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??


Top
 Profile E-mail  
 
 Post subject: Re: Job List with fields from different table
PostPosted: Thu Jul 12, 2012 4:32 pm 
Offline
MVP Microsoft Dynamics NAV
Site Supporter

Joined: Fri Jun 06, 2003 9:01 pm
Posts: 6978
Location: L.I., New York
Country: United States (us)
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:

_________________
Harry Ruiz
http://www.cosmeticsolutions.com
http://www.autismspeaks.org


Top
 Profile E-mail WWW  
 
 Post subject: Re: Job List with fields from different table
PostPosted: Thu Jul 12, 2012 6:38 pm 
Offline

Joined: Thu Apr 26, 2007 2:28 pm
Posts: 322
Location: Lawrenceburg, Kentucky
Country: United States (us)
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

_________________
Fostering a homeless, abused child is the hardest yet most rewarding thing I have ever done.


Top
 Profile  
 
 Post subject: Re: Job List with fields from different table
PostPosted: Thu Jul 12, 2012 8:41 pm 
Offline

Joined: Fri Sep 30, 2011 7:04 pm
Posts: 298
Country: Canada (ca)
I ordered two of the books and I will start going through them. \:D/

Thanks. 8)


Top
 Profile E-mail  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 4 posts ] 

All times are UTC + 1 hour [ DST ]


Who is online

Users browsing this forum: No registered users and 7 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum


Search for:
Jump to: