Hello Im quite new to ax and I need to do this:
I have a form with 2 data sources
1: BOM_tempTable (will change name later)
2: productConfigTable
In my form I have to show all the data in table 1 (bom_temptable)
so I made a design like this:
...
Grid:Grid
StringEdit:PalleId -> BOM_tempTable.PALLETID (keeps changing to CAPS)
StringEdit:ReolId -> BOM_tempTable.RackId
StringEdit:Hyldeid -> BOM_tempTable.ShelfId
StringEdit:Cover -> BOM_tempTable.Cover
There is also a dropdown box on the design that refers to a baseenum
with 4 items (Normal,PalleId,ReolId,HyldeId).
When you select a thing in the dropdown it will
run "BOM_tempTable_ds.executeQuery();"
The idea is then when you pick one of the items in the dropdown the
query should change to show the BOM_tempTable where (pickedItem)
dosnt excist on table 2 I done this to try and get it to work.
public void executeQuery()
{
MW_RM_ProductConfigTable _MW_RM_ProductConfigTable;
;
switch (sortSelect.selection())
{
case BOM_tempFormSortSelect::HyldeId :
select _BOM_tempTable
index hint idx
order by ShelfId
notExists join _MW_RM_ProductConfigTable
index hint bomIdx
where _MW_RM_ProductConfigTable.ShelfId == _BOM_tempTable.ShelfId;
break;
...(2 more case(s) with PALLETID and RackId)...
case BOM_tempFormSortSelect::Normal :
select _BOM_tempTable
index hint idx
order by recid;
break;
}
super();
}
But when I do this there arnt any change I still just get the same
date as when I open the form any help would be apriciated
(the drop down box works fine when I select somthing It starts to
scearch but the resault isnt correct cause I can find the items in
the grid that are on the productconfigtable and I only want the ones
that arnt there but are on bom_temptable)
on the table BOM_tempTable I made 3 relations
relation1
BOM_tempTable.PALLETID == MW_RM_ProductConfigTable
relation2
***.Rackid == ***.Rackid
relation3
***.ShelfId == ***.ShelfId
I tried using no relations and having all relations in one
I cant figure out what is wrong :E
