ALTER TABLE FOREIGN

[Robert Tulloch]

Hi:

Three tables. users, users_initial and users_dues

Trying to set relation form users_dues to users_initial in php MyAdmin SQL

SQL query:

ALTER TABLE users_dues
ADD FOREIGN KEY (user_id)
REFERENCES users_initial(user_id)
ON DELETE CASCADE
ON UPDATE CASCADE;

MySQL said: Documentation
#1146 - Table 'bwmjcmus_mem_mgr.users_dues' doesn't exist

The table does exist. Don't understand

bwmjcmus_mem_mgr

Procedures
Tables
Tables
sessions
users
users-dues
users-initial

Also, why isn't there an ON INSERT CASCADE?