Table Filtering without Coding

nari

hi everyone

now, im triying to set Table Filter in table relation property(Table 37 Sales Line) without using any Codes.
the reason why i cannot use code is, when i write codes(such as, SETFILTER and SETRANGE) in Onlookup trigger, Table Relation dont work.(i dont knowv the reson but no response. )
So i decided not to use Code and solve this issue by setting Table Filter(in properties.)
However, when i try to put range filter(something like ORDER DATE>TODAY) , it will not work.
Does anyone know how to do this?

im waiting for your reply

thanks.

nari

mohana_cse06

what exactly is your requirement?

Troubles_In_Paradise

nari wrote:

hi everyone

now, im triying to set Table Filter in table relation property(Table 37 Sales Line) without using any Codes.
the reason why i cannot use code is, when i write codes(such as, SETFILTER and SETRANGE) in Onlookup trigger, Table Relation dont work.(i dont knowv the reson but no response. )
So i decided not to use Code and solve this issue by setting Table Filter(in properties.)
However, when i try to put range filter(something like ORDER DATE>TODAY) , it will not work.
Does anyone know how to do this?

im waiting for your reply

thanks.

nari

maybe, you could try, for field Order Date, to set filter:

Workdate..

nari

well

i made new table(call A)and make relation to Sales Line by using table relation.
A is something like Price List and it also has Starting Date and Ending Date.
A's original field required to be in the Sales Line and it needs to be lookedup when you select that original field.
However, when you select that original field, it has to be filtered by Date(A:Ending Date>Sales Line:Order Date)

that is the problem

nari

What i wrote in Sales Line Original field is....

"Table A"."Original Field" WHERE (Customer No.=FIELD(Sell-to Customer No.),Item No.=FIELD(No.))

I would like to add is something like....

"Table A"."Original Field" WHERE (Customer No.=FIELD(Sell-to Customer No.),Item No.=FIELD(No.), Ending Date >FIELD(Order Date))

please help me

mohana_cse06

i guess the only way we have is through coding..

thmartin

As soon as you put code in the OnLookup trigger you overwrite the standard behaviour.
In your case you need additionally to the filter setting the coding of opening the lookup form and picking the value.
For an example look at the OnLookup trigger of field "Primary Contact No." in the Customer table.

pdj

The described request can be solved by a FlowFilter. Make a new field in table A called "Order Date Filter" (FieldClass=Flowfilter). Then set the filter you like in the OnOpenForm or maybe OnAfterGetRecords. Finally you can use the flowfilter in the TabelRelation like a normal field.

But your description is quite strange it doesn't make any sense to me, so I hope I misunderstand it... :?

But take a look in the on-line help regarding FlowFilters - a lot of people never use them, and you might find a way to solve it.

nari

thmartin wrote:

As soon as you put code in the OnLookup trigger you overwrite the standard behaviour.
In your case you need additionally to the filter setting the coding of opening the lookup form and picking the value.
For an example look at the OnLookup trigger of field "Primary Contact No." in the Customer table.

Finally Ive got answer! thank you so much!
But, i have another question.
i looked up "Primary Contact No." in the Customer table but it did not work in Table itself.However, in the Customer Form, I could looked up "Primary Contact No.".
Why this happens?
Does anyone know why it is happen?

nari

pdj wrote:

The described request can be solved by a FlowFilter. Make a new field in table A called "Order Date Filter" (FieldClass=Flowfilter). Then set the filter you like in the OnOpenForm or maybe OnAfterGetRecords. Finally you can use the flowfilter in the TabelRelation like a normal field.

But your description is quite strange it doesn't make any sense to me, so I hope I misunderstand it... :?

But take a look in the on-line help regarding FlowFilters - a lot of people never use them, and you might find a way to solve it.

oh mine. I think it is great idea too. i will try in the next time! thank you so much!
=D>