I've one display method field in my form, I want to create a filter for that.
How can I do that?
Please give your table name and the related table(Display method field's table)
// BP deviation documented
Display ItemId ItemNumber()
select prodTable where this.InventRefId == prodTable.ProdId;
This is the display method and table is purchline
I've created one inquiry form based on purchtable, purchline and inventdim table
Hi :-),It is not possible to filter the display or edit method in order to achieve that you need to create a view and map the view field in order to filter.
Add the data sources prodtable and inventtable...Get the ItemId field from InventTable
Just add the InventTable and relate with the itemid from the PurchLine... Then u can use the itemId from InventTable for filtering
shall i add datasource in my inquiry form directly
Yeah you can add the datasource
Yes I know that, but i created view and added the tables but records is not clear