Hi,

>>
I have 2 tables in my forms DE. I need to make a parent-child relation. With Table1 as the parent and table2 as the child.

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 no field, just an index in table1. How can I create a relation, making table1 the parent
<<

You will need an index on Table2.Field1. To create the relation in the IDE first create a relation from Table1.Field1 to this index then edit the RelationalExpr and OneToMany properities of the relation as required.

HTH,
Viv