Cascading prompts, filter on both entries

Hello all,

I’ve got a problem with my cascading prompt. It’s working alright but I need to filter on both objects, instead of only on the lowest level.

Situation:

I need to select a company (highest level). That returns a LOV of all contacts concerning this company (lowest level). This is working correct. But…

I’ve seen that filtering on both contacts AND company improves performance dramaticly! Therefor I wish to filter on both first and second prompt.

Anyone any Ideas?

Joep


jobjoris :netherlands: (BOB member since 2004-06-30)

The way the software currently works will require you to have the company in the condition as well.

Unfortunately, it will appear that you are prompting twice.

It will be interesting to see if 6.5’s @IndexAware functionality will help.


Steve Krandel :us: (BOB member since 2002-06-25)

Steve,

I’ve created a concatenated field, company-contact, and the final condition tears the selected concatenated field apart.

It’s working, but the lov is now showing this concatenated no with the name of the contact. Not real smooth to look at, but working just fine, you don’t have to enter the company-prompt twice.

Thanx for thinking about this matter. We’re desperately looking out for 6.5!

Joep


jobjoris :netherlands: (BOB member since 2004-06-30)