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





Sylvia