Hello,
I have two files, FileA and FileB, which is related to FileA via an ID.
Then I have a selection list with FileB as main DD (Not constrained to FileA), however, in that list, I would like to be able to use a form where the user can input a partial description, which I need then to use to constrain the records for FileB, where its related header record, contains these characters in it Description field.
Is there a way to implement this constrain keeping in mind that FileB has around 200.000 records, and FileA to which it is related, around 100.000 records?

SO for example, FileA has the following records

ID DESCRIPTION
1 PENS
2 PENCIL
3 PENICILIN


FileB

ID CODE PART
2 221 302-AA-101
2 222 302-AA-102
1 223 341-CA-117
3 224 341-SS-865

So when the user for example inputs "CIL" in that form (which is part of the description record from FileA), I would like the selection list for FileB to only show me the records with Code 221, 222 and 224 the parents of which contain the letters CIL in their description

Thank you
Yannis