Yes priyanka. You please re-consider. Is this customisation is need?? in table "Salesline" a field "linenum" is available. will it not be useful to you?? Ramanan
----- Original Message ---- From: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> To: Axapta-Knowledge-Village@yahoogroups.com Cc: axapta-knowledge-village@yahoogroups.com Sent: Thursday, 29 November, 2007 1:46:12 PM Subject: Re: [Axapta-Knowledge-Village] About lookup Hi, I am working on Axapta and have worked on the reports till this date.But now i have started to do customisation. I have few queries can you please help me with a certain issues The scenario is, I have added one new field in "Sales Line" called "Item SL No." with extended data type "InventSerialId" .There is one more field in sales line called "Service ItemID ".Now I want look-up in "Item SL No."(new field) on the basis of "Service ItemID", but the look up is coming according to ItemId. How can I do this?Pls help me.. Hi Neeraj, You can use the EDT relationship. There are two kind of relations possible in EDT, normal and related field fixed. If you want just a simple lookup like drop down of all customer accounts, simply create a normal relationship with custtable (with field Customer Account). You can also create a complex lookup using EDT relation. Suppose you want to show customers which are One time customers in a lookup. You have to first create a normal relation with custtable and then create a related field fixed relation where select the one time customer field and in the place of value, give '1' which means TRUE. You can use this relation and specify the value only for the enum type fields. Thats all, if you want more complex lookups, EDTs can't help you more. Barunava ----- Original Message ---- From: Arijit Basu <arijit.basu@ gmail.com> To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com Sent: Wednesday, November 14, 2007 4:56:43 PM Subject: Re: [Axapta-Knowledge- Village] About lookup Hi Neeraj, Use the EDT Relations Node. On 11/14/07, neeraj_gupta2k83 <neeraj_gupta2k83@ yahoo.co. in> wrote: > > hi all, > > i have used the lookup through code . is it possible to give lookup > using relations without using auto lookup. ???/ is any body know > solution please inform me. > > > -- Arijit Basu [Non-text portions of this message have been removed] <!-- #ygrp-mkp{ border:1px solid #d8d8d8;font- family:Arial; margin:14px 0px;padding: 0px 14px;} #ygrp-mkp hr{ border:1px solid #d8d8d8;} #ygrp-mkp #hd{ color:#628c2a; font-size: 85%;font- weight:bold; line-height: 122%;margin: 10px 0px;} #ygrp-mkp #ads{ margin-bottom: 10px;} #ygrp-mkp .ad{ padding:0 0;} #ygrp-mkp .ad a{ color:#0000ff; text-decoration: none;} --> <!-- #ygrp-sponsor #ygrp-lc{ font-family: Arial;} #ygrp-sponsor #ygrp-lc #hd{ margin:10px 0px;font-weight: bold;font- size:78%; line-height: 122%;} #ygrp-sponsor #ygrp-lc .ad{ margin-bottom: 10px;padding: 0 0;} --> <!-- #ygrp-mlmsg {font-size:13px; font-family: arial, helvetica, clean, sans-serif;} #ygrp-mlmsg table {font-size:inherit; font:100% ;} #ygrp-mlmsg select, input, textarea {font:99% arial, helvetica, clean, sans-serif;} #ygrp-mlmsg pre, code {font:115% monospace;} #ygrp-mlmsg * {line-height: 1.22em;} #ygrp-text{ font-family: Georgia; } #ygrp-text p{ margin:0 0 1em 0;} #ygrp-tpmsgs{ font-family: Arial; clear:both;} #ygrp-vitnav{ padding-top: 10px;font- family:Verdana; font-size: 77%;margin: 0;} #ygrp-vitnav a{ padding:0 1px;} #ygrp-actbar{ clear:both;margin: 25px 0;white-space: nowrap;color: #666;text- align:right; } #ygrp-actbar .left{ float:left;white- space:nowrap; } .bld{font-weight: bold;} #ygrp-grft{ font-family: Verdana;font- size:77%; padding:15px 0;} #ygrp-ft{ font-family: verdana;font- size:77%; border-top: 1px solid #666; padding:5px 0; } #ygrp-mlmsg #logo{ padding-bottom: 10px;} #ygrp-vital{ background-color: #e0ecee;margin- bottom:20px; padding:2px 0 8px 8px;} #ygrp-vital #vithd{ font-size:77% ;font-family: Verdana;font- weight:bold; color:#333; text-transform: uppercase; } #ygrp-vital ul{ padding:0;margin: 2px 0;} #ygrp-vital ul li{ list-style-type: none;clear: both;border: 1px solid #e0ecee; } #ygrp-vital ul li .ct{ font-weight: bold;color: #ff7900;float: right;width: 2em;text- align:right; padding-right: .5em;} #ygrp-vital ul li .cat{ font-weight: bold;} #ygrp-vital a{ text-decoration: none;} #ygrp-vital a:hover{ text-decoration: underline; } #ygrp-sponsor #hd{ color:#999;font- size:77%; } #ygrp-sponsor #ov{ padding:6px 13px;background- color:#e0ecee; margin-bottom: 20px;} #ygrp-sponsor #ov ul{ padding:0 0 0 8px;margin:0; } #ygrp-sponsor #ov li{ list-style-type: square;padding: 6px 0;font-size: 77%;} #ygrp-sponsor #ov li a{ text-decoration: none;font- size:130% ;} #ygrp-sponsor #nc{ background-color: #eee;margin- bottom:20px; padding:0 8px;} #ygrp-sponsor .ad{ padding:8px 0;} #ygrp-sponsor .ad #hd1{ font-family: Arial;font- weight:bold; color:#628c2a; font-size: 100%;line- height:122% ;} #ygrp-sponsor .ad a{ text-decoration: none;} #ygrp-sponsor .ad a:hover{ text-decoration: underline; } #ygrp-sponsor .ad p{ margin:0;} o{font-size: 0;} .MsoNormal{ margin:0 0 0 0;} #ygrp-text tt{ font-size:120% ;} blockquote{margin: 0 0 0 4px;} .replbq{margin: 4;} --> ____________ _________ _________ _________ _________ _________ _ Never miss a thing. Make Yahoo your home page. http://www.yahoo. com/r/hs [Non-text portions of this message have been removed] Save all your chat conversations. Find them online at http://in.messenger.yahoo.com/webmessengerpromo.php [Non-text portions of this message have been removed]