André
don't think about segment and sub maybe it's wrong example
the code in the lookup is
public void lookup()
{
Query query;
Form _formControl;
SysTableLookup sysTableLookup;
QueryBuildRange queryBuildRange;
QueryBuildDataSource queryBuildDataSource;
//Table7 table7;
// Instantiate sysTableLookup object using table which will provide the visible
sysTableLookup = SysTableLookup::newParameters(tableNum(a_Locations),this);
query = new Query();
queryBuildDataSource = query.addDataSource(tableNum(a_Locations));
sysTableLookup.addLookupfield(fieldNum(a_Locations,Locations));
sysTableLookup.parmQuery(query);
sysTableLookup.performFormLookup();
}
and in a_Departments
public void lookup()
{
Query query;
Form _formControl;
SysTableLookup sysTableLookup;
QueryBuildRange queryBuildRange;
QueryBuildDataSource queryBuildDataSource;
//Table7 table7;
// Instantiate sysTableLookup object using table which will provide the visible
sysTableLookup = SysTableLookup::newParameters(tableNum(a_Departments),this);
query = new Query();
queryBuildDataSource = query.addDataSource(tableNum(a_Departments));
sysTableLookup.addLookupfield(fieldNum(a_Departments,a_DepartmentId));
sysTableLookup.addLookupfield(fieldNum(a_Departments,Name));
sysTableLookup.parmQuery(query);
sysTableLookup.performFormLookup();
}
so when i open department edit just display the departments related to it's location that selected in locations edit
sorry if i can't explain the issue correctly
