How implement "or" filters in forms by code

Dduran

Hi,

I want open job card form filtered by two fields but with “or” conditions. For example the code of department “dep1”, or the code of Person Responsible “resp2”. Until now I have done looking for it and mark os with the mark (true) intrucción and then opening the form with Markedonly.

Do you Know a better solution?

Thanks :roll:

giulio.cipo

i don't know if is better but standard sometimes use this solution (e.c - in item tracking):

insert record in a temporaly table and pass it to the form

kine

Yes, there are just two ways: Temp table and marks...

Miklos_Hollender

There is a third way: http://mibuso.com/dlinfo.asp?FileID=515

But, this is simply not the right way to go. Rather, you should create a boolean or option field and update it whenever it is appropriate, forever, in you case, in the OnValidate of person responsible and dept. And then just filter for it.

kine

Miklos Hollender wrote:

But, this is simply not the right way to go. Rather, you should create a boolean or option field and update it whenever it is appropriate, forever, in you case, in the OnValidate of person responsible and dept. And then just filter for it.

But do not do it for example when form is opening etc. else you can have big problem with performance and locking... :-)