Lookup fields and self referencing tables.
Is there any reason why using a Lookup field to select a record from the
same table doesn't work?
For a CMS system, I wish to create a hierarchy of web pages where
sub-pages 'point' to their parent page which itself is a child
page of another parent page etc.
I don't want to limit the number of levels that the web site requires.
The most structured way of pointing to another page is to use a
Lookup field for the ID of that page. I have tried to do this put the
field doesn't appear in the form. Does ZC disallow a form to
lookup records in the same table?
Is there an elegant way of doing this?