Synthetic key in cross table?

[#1]

Hi,

Please find attached. can anyone let me know how to remove synthetic keys? in cross table.

Thanks.

[#2]

Please can anyone help me.

[#3]

Please find attached.

[its_anandrjs · Accepted solution]

Hi,

Identify which is the most important key and fields in the tables and keep those other wise remove unwanted keys or rename those keys for use on other references.

Another way is make composite key with synthetic fields by identifying those.

Eg.

Table1 Field1&Field2&Field3 as Key1

Table2  Field1&Field2&Field3 as Key1

Thanks & Regards

[ashwanin]

use Concatenate

or else provide the excel file.

[#6]

Thanks.