>I need to make a form that will handle a parent child relation that I can view, edit, or add to the child or parent table. How can I read the relations of the tables that are used in the form so I can give the user the option to add to the parent or child table?
>
>Thanks
If you are talking about relations that are set at design time in the DE, then these appear as objects in the DE. You can get to them with something like:
lnDEMemberCount =AMEMBERS(aDEMembers, THISFORM.DataEnvironment, 2)
FOR i = 1 TO lnDEMemberCount
oDEObj = EVAL('THISFORM.DataEnvironment.' + aDEMembers[i])
IF LOWER(oDEObj.BaseClass) = "relation"
?oDEObj.ChildAlias
?oDEObj.ParentAlias
?oDEObj.ChildOrder
ENDIF
ENDFOR
HTH
Erik Moore
Clientelligence