Dreamweaver MX & mySQL

[munkyonline.co.uk]

I'm pretty new at this and am learning as I go along. I'm having trouble understanding why Dreamweaver MX will pick up all the tables for my databases in the database panel but when I try and use a certain one to make a recordset from the bindings panel - the fields don't come up in the 'wizard'. This happens even if I have manually inserted info into the table using phpMyadmin. Yet afterwards if I create the recordset anyway - the fields are displayed in the bindings panel.

I also have the same sort problem when using the insert record feature with the same recordset and table. The form input names/id's are not displayed in the 'wizard' with the fields from the table in the database. If I try and insert a record into any of the other tables then they work fine.

This has completely confused me! I know it's something i'm doing/ Dreamweaver MX as it's doing the same with Oneandone and Verio as the host.

Any help will be greatly appreciated!

 

[munkyonline.co.uk]

I've narrowed it down now to two of the enum values. I think i may be able to work it out now. Thanks for all your help lol