Filter records on list page based on related table

EvR

Hi all,

Imagine this situation.
- A list based on the Sales Line table.
- On opening the list I want to filter the records shown based on the Status of the Item that is related to the Sales Line.

So I cannot filter in the SourceTableView because it displays the Sales Line and not the Item table.
How would I go about doing this the correct way?

Gr,
Erik

vaprog

Hi Erik,

If it is possible, it is best to use a FlowField in the Sales Line table.

If this is not possible, you might consider using a page based on a temporary sales line table, which you populate according to your filter condition.

And finally, you can filter the real table using code by implementing OnFindRecord and OnNextRecord triggers.

vaprog

Hi Erik,

If it is possible, it is best to use a FlowField in the Sales Line table.

If this is not possible, you might consider using a page based on a temporary sales line table, which you populate according to your filter condition.

And finally, you can filter the real table using code by implementing OnFindRecord and OnNextRecord triggers.

EvR

Thanks. I was hoping to avoid using flowfields.
I guess a temp table is the most elegant without fetching unused records from the database.

If only you could map a query to a page directly....

m_berger

Another way, without using flowfields, is using a OnFindRecord, OnNextRecord construction. Examples can be found in pages 9311, 9312 and many others.

[edit]Really should read the comments better, it had already been said