General information
Category:
Forms & Form designer
Title:
Setting a relation in the DE of a form
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.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only