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??
S.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]
Now you can chat without downloading messenger. Go to
http://in.messenger.yahoo.com/webmessengerpromo.php
[Non-text portions of this message have been removed]
