>>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
>
>do this without spaces between symbols and PRE

I haven't selected a table yet when I issue the Set Relation to commands (it's the last thing I do, and then I Select cfpeople). Yes, I am setting up a lot of relationships in the DBC, including the one with which I'm having trouble. I have a primary index on my cfjobtyp table (indexed on jo_jobid, an integer type), and it links to the pe_jobid index in the cfpeople table.