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

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.

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