Changed my approach and used the BudgetCycle method editCycleStartDate and editCycleEndDate
private void calendarYearLookup(FormStringControl _lookup)
{
Query query = new Query();
QueryBuildDataSource qbds;
SysTableLookup sysTableLookup;
if(_lookup != null)
{
sysTableLookup = SysTableLookup::newParameters(tableNum(BudgetCycle), _lookup);
qbds = query.addDataSource(tableNum(BudgetCycle));
qbds.addSortField(FieldNum(BudgetCycle, Name),SortOrder::Ascending);
qbds.fields().addField(fieldNum(BudgetCycle, StartFiscalCalendarPeriod));
qbds.fields().addField(fieldNum(BudgetCycle, EndFiscalCalendarPeriod));
sysTableLookup.addLookupField(fieldNum(BudgetCycle, Name), true);
sysTableLookup.addLookupMethod(tableMethodStr(BudgetCycle, editCycleStartDate));
sysTableLookup.addLookupMethod(tableMethodStr(BudgetCycle, editCycleEndDate));
sysTableLookup.parmUseLookupValue(false);
sysTableLookup.parmQuery(query);
sysTableLookup.performFormLookup();
}
Thanks!
