Maybe I need to explain further.

table1.Field1 & table1.Field2 together make up my primary key for that table.

str(field1)+'.'+str(field2) is my primary key.


I have another table that has that key value stored in a field .
table2.field1=(str(table1.field1))+'.'+(str(table1.field1))

I need to create a relation. The only relation it will allow me to create in the DE is by making table2 the parent. This will not work for me, I need table1 to be the parent table. It wont let me create that relation. Because there is not field, just an index in that table.

So I thought If I could create an additional field that was calculated in table1, I could use it for the parent relation.

Maybe there is another solution??