Wildcards in Key Fields

[Eric W]

Hi All

I'm curious to know whether it's possible to construct a key (global) that emulates the * wildcard from find mode but operates on a relationship.

eg Two fields in a table and a separate file with globals.

Field one is a product code and field 2 a product name.

Say for example we have the 1000 series, 2000 series etc in the product codes and they end with 08, 09 etc for a year.

Is it feasible to construct a pair of keys for the relationship that accepts such things as 1*09 or 2*09 or the more complex variations like 1*0809 and returns the appropriate Descriptions to a value list ?

And if so is it efficient where the tables begin to run to 20 to 40,000 records on server ?

Kind Regards

Eric

[comment]

It's not possible, at least not on the parent side. But you can easily split out the required elements into individual fields on the child side and use them as matchfields.

[Eric W]

Hi

I sort of thought so but was hoping.

I'm half thinking using the * as a delimiter with Get Values may be an opening to a highest lowest value for a key but am not sure and was hoping someone has already worked it out.

Kind Regards

Eric