Option Filter

sneha · 2009-10-21

How can I do this?

In Item table, ItemType is a option field with option values A,B,C
I want to filter ILE in OnOpen form, of Item Type A. I don’t want to add Item Type field to ILE

kapamarou · 2009-10-21

sneha wrote:

I don’t want to add Item Type field to ILE

Why? :-k

There are ways...
But you'll need to loop your entries and either Mark your records or copy your records to a temporary record variable and open the form based on that.

Each solution has pros and cons.

In both cases, too many entries would slow you down...

From where do you open the form?

PS: I would add the field...

Alex_Chow · 2009-10-22

sneha wrote:

How can I do this?

In Item table, ItemType is a option field with option values A,B,C
I want to filter ILE in OnOpen form, of Item Type A. I don’t want to add Item Type field to ILE

You basically have to GET the Item and do a currreport.skip if the conditions are met.

I highly recommend that you save yourself the headache and just create a field or a flowfield to filter on.

sendoh · 2009-10-22

I think Temporary record on form will do since you don't want to add a field on ILE,Use the SourceTableTemporary properties and insert the records when met your filters.

matttrax · 2009-10-22

Definitely add the field. Your solution, to get the item, then mark the ILEs or put them in a temp table, is going to take longer and longer as your item master grows.

It's a pretty simple modification to add the field / flowfield to the table.

sneha · 2009-10-23

Thanks to all, I added a flowfield to ILE

kapamarou · 2009-10-23

I think it was the best road to follow... :thumbsup:

Option Filter

Answers

Categories