Hello Wayne,

3 people have addressed the issue: you shouldn't be using a UDF for the index. You don't need to use the view wizard in order to make a view. See CREATE SQL VIEW in help and use the AS SQLDELECTStatement clause.

Before you actually create the view, you can work on a SELECT statement in the command window that returns the results you need. If you need help with the JOINS, show your table layouts and folks here will give you help.

>I have 1 parent table, 2 child tables and 1 grandchild table. I can relate the parent to 1 child and then to 1 grandchild. I cannot relate the parent to a second child table in a view (according to the view wizard). I still don't understand why I can't get an index based on a UDF to work. Nobody has really addressed that issue.
>
>Thanks for your help.