>>>I have a number of tables for which I'm trying to set relationships, but for one I keep getting the "Cyclic Relation" error. I've looked at both tables and indexes and can't figure out what the problem is. Here is the code which opens the tables in my Load event (I read I was supposed to add a PRE tag to this code, but wasn't sure how to do that so hope it comes across OK) :
>>>
>>>l_cOpenerror=l3open(;
>>> "cfpeople order pe_peoplid share",;
>>> "cfprefix order pr_prefix share",;
>>> "cfsuffix order su_suffix share",;
>>> "cfaddres order ad_peoplid share",;
>>> "cfadtype order at_typeid share",;
>>> "cfdistri order di_distcod share",;
>>> "States order st_code share", ;
>>> "cfjobtyp order jo_jobid share")
>>>
>>>
>>>*Move the record pointer in address to match the selected address
>>>SET RELATION TO pe_peoplid INTO cfaddres IN cfpeople
>>>*Move the record pointer in district to match the selected district code
>>>SET RELATION TO pe_distric INTO cfdistri IN cfpeople ADDITIVE
>>>*THIS IS WHERE I GET THE CYCLIC RELATION ERROR
>>>SET RELATION TO pe_jobid INTO cfjobtyp IN cfpeople ADDITIVE
>>>
>>
>>which table is selected when you set the relations? are any relations set in your dbc?
>>
>>using pre is < PRE >
>>
>>at end of preformat

A table must be open in the currently selected work space or the relation cannot be set. which table is in the active work space?