Hi Eric,

Thanks for the reply and the help for that part of the puzzle. I am trying to come up with a generic form to add edit view 1 to many type of related tables. I hope to drop the parent table and the child table in a form then drop in some controls to view add edit the tables. This is mostly for maintenance of the tables. I think that at this point I need some general pointers on building this generic form. I am having trouble getting it all to blend into one clear outline of what I need to do. Any help is welcomed.


>>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