HI, I previously tried this same question on the GUI tool list, but not much traffic there, so I thought I'd give it a go here. I've been reading some articles that suggest I should be able to create a relationship on a MyISAM table, it would be great if someone could confirm or deny this. --------------------------- Hi all, has anyone experienced any problems creating foreign keys (relationships) on tables that are of storage engine MyISAM? I can't seem to be able to create any relationships on those tables in MySQL Administrator 1.1.8 Any help would be much appreciated. Kind regards,
Taco Fleur - CEO Free Call 1800 032 982 or Mobile 0421 851 786 Pacific Fox <http://www.pacificfox.com.au/> http://www.pacificfox.com.au an industry leader with commercial IT experience since 1994 . * Web Design and Development * SMS Solutions, including developer API * Domain Registration, .COM for as low as fifteen dollars a year, .COM.AU for fifty dollars two years!