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 on the web, go to:
> http://groups.yahoo.com/group/development-axapta/
> <http://groups.yahoo.com/group/development-axapta/>
>
>
> * To unsubscribe from this group, send an email to:
> [EMAIL PROTECTED]
>
<mailto:[EMAIL PROTECTED]>
>
>
>
> * Your use of Yahoo! Groups is subject to the Yahoo!
> Terms of Service
> <http://docs.yahoo.com/info/terms/> .
>
>
>
=== message truncated ===
__________________________________
Do you Yahoo!?
Win a $20,000 Career Makeover at Yahoo! HotJobs
http://hotjobs.sweepstakes.yahoo.com/careermakeover
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
