# form controls lookup...

**URL:** https://www.dynamicsuser.net/t/form-controls-lookup/34579
**Category:** Developer Forum
**Created:** [December 19, 2011, 5:57am UTC](https://www.dynamicsuser.net/t/form-controls-lookup/34579 "2011-12-19T05:57:15Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![venky20mca](https://avatars.discourse-cdn.com/v4/letter/v/9e8a1a/32.png) [@venky20mca](https://www.dynamicsuser.net/u/venky20mca)
#### Post date: [December 19, 2011, 5:57am UTC](https://www.dynamicsuser.net/t/form-controls-lookup/34579/1 "2011-12-19T05:57:15Z")

</div>

hi,

i need to fetch the categorys in a lookup basing on the categorygroup in a form. this to fields in the table SMAAgreement table and i added projCatogoryId and projCategoryGroupId EDT 's for those fields respectively.

can u please suggest me to acheive this?

i wrote the code as follows in the formControl projCategoryId in the design part of the form.

public void lookup()  
{  
Query query= new Query();  
QueryBuildDataSource queryBuildDataSource;  
QueryBuildRange queryBuildRange;  
SysTableLookup sysTableLookup;  
;

sysTableLookup = SysTableLookup::newParameters(tablenum(SMAAgreementLine),this);

queryBuildDataSource = query.addDataSource(tablenum(SMAAgreementLine));  
sysTableLookup.addLookupfield(fieldnum(SMAAgreementLine, projCategoryId),true);

queryBuildRange = queryBuildDataSource.addRange(fieldnum(SMAAgreementLine, projCategoryGroupId));  
queryBuildRange.value(SMAAgreementLine.ProjCategoryGroupId);

sysTableLookup.parmQuery(query);  
sysTableLookup.performFormLookup();

//super();  
}

but it is showing empty grid in the lookup…