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. Any ideas? - Gyrus ~~~~~~~~~~~~~~~~~~~~~~~~~~~~ - [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net - PGP key available ~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ______________________________________________________________________ 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
