Event Rule help...

I am working on some logic that needs to loop through my lookup table to determine which values to use

Ie. In looking into the F0618 table, I only want to grab certain PDBA codes

I have written the code to loop through my table and add each PDBA to the Set User Selection...

I was just wondering if there was a way to mimic the Data Selection List of Values (I think this would be faster) just don't know if it is possible.

Hope this makes sense

Pam

pbare,

There is not a magic 'list' option for Data Selection, within ER (which REALLY SUCKS!).

You might play with creating a 'dummy' section with the lists of DBAs you desire to be in the section's 'external data selection'.

Then, you can apply the System Function (under General):
"Use Data Sel/Seq from a Section"
to apply the data selection from the dummy section.

Maybe this would be another Tips/Traps post (getting me ready for Collaborate!)

(db)

Why not create a BV that joins on your list of values.

I am not sure why I didn't think of that I seem to always overthink the obvious.

Thanks, I'll give that a try
Pam

Hi Pam,

What about a BSVW over the lookup table and the other?
(simple join)

Regards,

Zoltán