> I've got a table with details of pages in a site. There's > a pageID, and also a parentID. If the page has no parent, > this is 0, otherwise it's the same as the pageID of the > parent. > > What's the deal with having Foreign Keys that aren't exactly > er... foreign?! I pretty much know this is "doable" cos I've > done it before, but I'm trying to define the relationship > with Access 2000's GUI, and I can't seem to get it to > recognise parentID as being related to the pageID in the > same table.
I don't think that the Access Relationship Builder GUI supports self-referential relationships, or "fishhooks" as they're sometimes called. I think you'd have to build that manually, using SQL, and even that may not be supported by Access for all I know. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ______________________________________________________________________ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
