Skip to Content
0
Former Member
Apr 06, 2009 at 02:22 PM

Dynamic Filter Capabilities

29 Views

Hello,

We are trying to write a query that will allow an end user to select a "BOM" number from a selection field, and based on the "BOM" number selected, allow the user to select from the available dates where this BOM has been changed. I wrote the query below but when I select a BOM, the dates field lists every date any BOM was changed as an available entry. Does anyone have any pointers on how to only display "existing values" for the update date that pertain to the BOM number selected.

SELECT T0.Code,T2.FrgnName, T0.UpdateDate, T0.loginstac,T1.ChildNum, T1.Code, T3.FrgnName, T1.Quantity, T1.Warehouse, T1.Price FROM AITT T0 inner join ATT1 T1 on T0.code=T1.father and T0.loginstac=T1.loginstanc INNER JOIN OITM T2 ON T0.Code = T2.ItemCode INNER JOIN OITM T3 ON T1.Code = T3.ItemCode WHERE T1.Father ='[%0]' and T0.UpdateDate ='[%1]'

If you have any ideas on how to include this dynamic filter capability please help.

Thanks,

Jordan