No, it is supported in Access, sort of. Easiest way to do it is to add the table to your diagram twice. Then you can create the relationship just as you would if it were between two different tables.
At 01:42 PM 02/05/2002 -0500, you wrote: > > 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. -- Jeffry Houser | mailto:[EMAIL PROTECTED] AIM: Reboog711 | ICQ: 5246969 | Fax / Phone: 860-223-7946 -- Need a Web Developer? Contact me! My Book: Instant ColdFusion 5 | http://www.instantcoldfusion.com My New Book: ColdFusion: A Beginner's Guide February 2002 -- Far Cry Fly, Alternative Folk Rock http://www.farcryfly.com | http://www.mp3.com/FarCryFly ______________________________________________________________________ Why Share? Dedicated Win 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=coldfusionc 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
