>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.
How can you do this? Every time you open a view you have to re-create any indexes. When you open a view, a temporary DBF is created, so when you close the view, the index is gone.
Mark McCasland
Midlothian, TX USA