View/Table One-To-Many Syntax Error.

[andyk]

Dear All,

I'm getting a less than helpful 'Syntax Error' when I'm issuing a 'SET RELATION' command. The situation is this:

I've got a view which I'm using at the 'one' end of the relation and a table for the 'Many' end. The table is actually one of the base tables of the view. The relationship between the view and table is that the table contains a 'Mother' field that either stores NULL or the primary index integer for the entry of its mother.

I'm issuing the following commands in the Command Window:

use people in 0 alias children
select children
set order to ip_people && Primary index.

use peopleview in 0
select peopleview
set relation to i_mother into children

I had this type of relation working fine between to simple tables. Is the problem here to do with the self-referential index?

Any ideas would be gratefully received.

Thanks Andy.