Which is faster in 7...basing a relationship on a calculation field in two tables that concatenates two fields or basing a relationship on those two fields simultaneously between tables as you now can in 7? This will be for very large databases (many millions of records) so speed is very important.

Which is faster in 7...basing a relationship on a calculation field in two tables that concatenates two fields or basing a relationship on those two fields simultaneously between tables as you now can in 7? This will be for very large databases (many millions of records) so speed is very important.

Which is faster in 7...basing a relationship on a calculation field in two tables that concatenates two fields or basing a relationship on those two fields simultaneously between tables as you now can in 7? This will be for very large databases (many millions of records) so speed is very important.

I would think using the individual fields would be faster. But if both calculations can be indexed, then the difference may be negligible. Of course, there is no reason to create the concatenated fields since you can use the multi-criteria relationship and also save a lot of file space, especially over millions of records.

I would think using the individual fields would be faster. But if both calculations can be indexed, then the difference may be negligible. Of course, there is no reason to create the concatenated fields since you can use the multi-criteria relationship and also save a lot of file space, especially over millions of records.

I would think using the individual fields would be faster. But if both calculations can be indexed, then the difference may be negligible. Of course, there is no reason to create the concatenated fields since you can use the multi-criteria relationship and also save a lot of file space, especially over millions of records.

Hi,

The only resistance of a compound (concanated) calculation is when one of the key of this compound can be empty.

You can search for a Matching ID where the second key is empty with a compound calc.

Hi,

The only resistance of a compound (concanated) calculation is when one of the key of this compound can be empty.

You can search for a Matching ID where the second key is empty with a compound calc.

Hi,

The only resistance of a compound (concanated) calculation is when one of the key of this compound can be empty.

You can search for a Matching ID where the second key is empty with a compound calc.