Hi,
First of all – when speaking of relationships (and Clarion), I think one is referring to relationships between two files.
One solution to the problem: Make a common field and a Key thereof. E.g. two records in a customer file can be related through order date key. In that way to records with the same order date will be related.
Regards,
Aslak E. Himle