nuBuilder Forum

Hi,
I was having trouble setting up foreign keys, subform to parent form. And After doing some research I found that tables created in nuBuilder forte are made in MyISAM storage engine by default. I have done a re-install of nuBuilder once already, and I believe the first time I installed it, new tables WERE defaulting to InnoDB. But MyISAM doesn't support foreign keys. To fix, I went into phpMyadmin, select a table, click "Operations" at the top and change the storage engine. Then you can setup foreign keys with an sql statement or phpMyadmin gives you a handy GUI for it under table structure/relation view.

ben,

nuBuilder allows you to use any field as a foreign key even if it is not recognised as so by the Mysql database.

In other words, you don't need to create foreign keys within MySQL/PHPMyAdmin for nuBuilder to work.


Steven