Dear Amit and Harry,
Thanks for your prompt answer and sorry for my late
reply as I am a slow learner.
I've successful it by using sysTableLookup. Below is
my code.
Thanks again Amit and Harry.
Bye
kamtt
public void lookup()
{
Query query = new Query();
QueryBuildDataSource queryBuildDataSource;
QueryBuildRange queryBuildRange;
SysTableLookup sysTableLookup =
SysTableLookup::newParameters(tableNum(custTable),this);
;
sysTableLookup.addLookupfield(fieldNum(custTable,
accountNum));
sysTableLookup.addLookupfield(fieldNum(custTable,
Name));
queryBuildDataSource
=query.addDataSource(tableNum(custTable));
queryBuildRange =
queryBuildDataSource.addRange(fieldNum(custTable,
accountNum));
queryBuildRange.value(CallerTable_CallerId.text());
sysTableLookup.parmQuery(query);
sysTableLookup.performFormLookup();
}
--- Deshpande, Harry [EMAIL PROTECTED]
wrote:
hi Amit!
Hmmm, I guess adding a new datasource is better than
adding a new field or
creating a new look up form, but personally speaking
I avoid adding a new
datasource unless its absolutely required. Just my
way of thinking. no real
rational behind this.
regards
harry
-Original Message-
From: Amit Jain [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 28, 2004 6:09 PM
To: [EMAIL PROTECTED]
Subject: RE: [development-axapta] Customised
Filtering
Hi Harry
First thing i m not suggesting that Kamtt should
create another field for
itemgroup, but from the statement of Kamtt it looks
like that they are
already using ItemGroup field in SalesLine table. If
creation of new field
is a problem then might be he can create a new
datasource for ItemGroup and
then use sysTableLookTable class. but i won't
suggest creation of new forms
only for look until and unless it cannot be done
another way. This is what
my personal experience says.
What ur opinion.
Regards
Amit
Deshpande, Harry [EMAIL PROTECTED]
wrote:
hi Amit!
Interesting!
The problem with what you are proposing is ...
Either I have to create a field to hold the value of
'ItemGroupId' on
salesLine. This field does not serve any purpose
after a line has been
created and violates the 'Normalization' rule for
the data. It also takes up
unnecessary disk space.
One can also create just an extended data type field
on the saleTable form
(in the sales line grid). However, this means..if i
specify an item group
and go to second line to specify a different item
group the first item group
changes. This will create confusion for the viewer.
This is why I recommended a different lookup form on
the ItemId with two
tabs like the 'location' look up form.
Do let me know if you find some problem with the
above thinking.
regards
harry
-Original Message-
From: Amit Jain [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 28, 2004 4:50 PM
To: [EMAIL PROTECTED]
Subject: RE: [development-axapta] Customised
Filtering
Hi
For this u must have created a data field for
itemgroup in the salesline
form. you can anytime override the lookup method of
the itemid field in
SalesLine datasource to control the way look up
behaves. All you have to do
is use sysTableLookup Class. Refer Axapta's help for
this. If you still face
problem then let me know.
Regards
Amit
Deshpande, Harry [EMAIL PROTECTED]
wrote:
hi
On second thoughts...
It will be better if you could change your look up
form on the item id to
the format of the look up form on the field
warehouse (on salesline). So the
new lookup with have two tabs. On first tab show
itemgroup and on second tab
show related items. this will make things easier.
regards
harry
-Original Message-
From: kamtt [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 27, 2004 7:18 PM
To: [EMAIL PROTECTED]
Subject: [development-axapta] Customised Filtering
Hello,
I am new for Axapta and I have encounter below
problem.
In Sales Line of Sales Order, I would like to select
an ItemGroup
first and then it will automatically filter and
shows for Item
Numbers which are only related to selected
ItemGroup.
I don't want to jump to Item Number and filter using
standard. In
this way, user need to select ItemGroup first and
and it will show
filtered Item Numbers when he dirll down on Item
Number field.
Please advice me how to solve the problem.
Thanks in advance,
kamtt
_
Do you Yahoo!?
Win
http://pa.yahoo.com/*http://us.rd.yahoo.com/hotjobs/hotjobs_mail_signature_
footer_textlink/evt=23983/*http://hotjobs.sweepstakes.yahoo.com/careermakeov
er a $20,000 Career Makeover at Yahoo! HotJobs
_
Do you Yahoo!?
Win
http://pa.yahoo.com/*http://us.rd.yahoo.com/hotjobs/hotjobs_mail_signature_
footer_textlink/evt=23983/*http://hotjobs.sweepstakes.yahoo.com/careermakeov
er a $20,000 Career Makeover at Yahoo! HotJobs
_
Yahoo! Groups Links
* To visit your group