Cannot set up referential relationship in MySQL

I have 6 tables 1. course 2. groups 3. group_members 4. group_events 5. events 6. users Users is the parent table for group_members Courses is the parent table for groups events is the parent table for group_events groups is the parent table for group_members and group_events (Parent table here

Re: Cannot set up referential relationship in MySQL

Never mind. I found the problem. It is because I have some course_id in groups which do not exist in courses. On Nov 4, 3:50 pm, Steveston [EMAIL PROTECTED] wrote: I have 6 tables 1. course 2. groups 3. group_members 4. group_events 5. events 6. users Users is the parent table for