Partial keys match

[#1]

Is it possible to create a partial key where A & '|' & B & '|' would be equal to A & '|' & B & '|' & C or one involving a wildcard. For what its worth, could the first two elements be text and the third be a date or a wildcard date.

[stephencredmond]

Hi,

No. You need to have complete keys.

You can though create multiple copies of the keys for different connections. Connect A & B & C for connection to one table and A & C to another.

You might also look at Interval Match where you have ranges of dates that you want to match.

Stephen