> Are you sure that the "relationships" are only used in the Access GUI? My > understanding is that they were true constraints.
You're right, I believe - only I've never had a single problem so far with not defining them inside the DB (apart from PK's, which Access forces, and I've got into the habit of defining by default). "So far" is probably the operative part of this, though! I'm incredibly thorough with my code that inserts data, but I appreciate that I should get into the habit of defining relationships explicitly. I was asking really to make sure I didn't get any replies going, "Ohmigod!! You haven't defined the relationships!! All your sites are about to crash!" Well, as I said, nothing bad so far, but will bear this advice in mind... cheers, - Gyrus ~~~~~~~~~~~~~~~~~~~~~~~~~~~~ - [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net - PGP key available ~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ______________________________________________________________________ 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

