Vidushi
Member
Hello,
I have created a subform on a powerform. In that subform there is a Grid, a Form control and a Find Button. The Business view is a combination of F0101, F0116 and F03012. That Form control is State (F0116.ADDS) and after selecting the state one will click "Find" button and the records should be shown in the Grid. But I have to put more filters like
F0101.AT1 = C
F03012.BADT = S , X
F03012.CO = 00000
which i have written one the Find Button "Button Clicked" event like
Clear Selection(FC Grid)
Set Selection Append Flag(FC Grid, <Yes>)
Set Selection(FC Grid, "F0101", "AT1", <Equal To>, "C", <And>)
Set Selection(FC Grid, "F0116", "ADDS", <Equal To>, FC State, <And>)
Set Selection(FC Grid, F03012, "CO", <Equal To>, "00000", <And>)
Set Selection(FC Grid, F03012, "BADT", <Equal To>, "S", <And>)
//
Set Selection(FC Grid, F0101, "AT1", <Equal To>, "C", <Or>)
Set Selection(FC Grid, "F0116", "ADDS", <Equal To>, FC State, <And>)
Set Selection(FC Grid, F03012, "CO", <Equal To>, "00000", <And>)
Set Selection(FC Grid, F03012, "BADT", <Equal To>, "X", <And>)
Its working perfectly fine when i am selecting a State value and clicking Find. But now i want to put Address Number value in the QBE of the Grid and will Click find and it should find records accordingly(means along with the above filters show address number value) but that is not happening.
I tried all sorts of combination but its not happening means I tried putting one more selection with
Set Selection(FC Grid, F0101, "AN8", <Equal To>, QC AddressNumber, <And>) -- Not working
and i tried giving address number as a Form Control same as State and then putting one more selection like
Set Selection(FC Grid, F0101, "AN8", <Equal To>, FC Address_Number, <And>) -- Still not working
suggest me what i am doing wrong???
basically I want to search with State and Address Number value along with above filters.
Thanks in advance
I have created a subform on a powerform. In that subform there is a Grid, a Form control and a Find Button. The Business view is a combination of F0101, F0116 and F03012. That Form control is State (F0116.ADDS) and after selecting the state one will click "Find" button and the records should be shown in the Grid. But I have to put more filters like
F0101.AT1 = C
F03012.BADT = S , X
F03012.CO = 00000
which i have written one the Find Button "Button Clicked" event like
Clear Selection(FC Grid)
Set Selection Append Flag(FC Grid, <Yes>)
Set Selection(FC Grid, "F0101", "AT1", <Equal To>, "C", <And>)
Set Selection(FC Grid, "F0116", "ADDS", <Equal To>, FC State, <And>)
Set Selection(FC Grid, F03012, "CO", <Equal To>, "00000", <And>)
Set Selection(FC Grid, F03012, "BADT", <Equal To>, "S", <And>)
//
Set Selection(FC Grid, F0101, "AT1", <Equal To>, "C", <Or>)
Set Selection(FC Grid, "F0116", "ADDS", <Equal To>, FC State, <And>)
Set Selection(FC Grid, F03012, "CO", <Equal To>, "00000", <And>)
Set Selection(FC Grid, F03012, "BADT", <Equal To>, "X", <And>)
Its working perfectly fine when i am selecting a State value and clicking Find. But now i want to put Address Number value in the QBE of the Grid and will Click find and it should find records accordingly(means along with the above filters show address number value) but that is not happening.
I tried all sorts of combination but its not happening means I tried putting one more selection with
Set Selection(FC Grid, F0101, "AN8", <Equal To>, QC AddressNumber, <And>) -- Not working
and i tried giving address number as a Form Control same as State and then putting one more selection like
Set Selection(FC Grid, F0101, "AN8", <Equal To>, FC Address_Number, <And>) -- Still not working
suggest me what i am doing wrong???
basically I want to search with State and Address Number value along with above filters.
Thanks in advance