I am having a problem with a relationship between a parent table and 6 child tables. the child tables are infact views. I am having no problem setting the index on the tables and then the proper order but as soon as my set relationship command executes I get a cyclic relation error.
this error only occurs when I run the form that runs this code.
however if I set the relationships from the data session window and the command window manualy, everything seems to work just fine.
any ideas what my problem could be?

Thanks.