MySQL relationship

[plarts]

After a migration from Access to MySQL V5,
I have lost the Access relationship.
I tried to recreate them into MySQL, through declaration of foreign keys
and delete cascade.
When inserting my first data , I had this CF error :

Cannot add or update a child row: a foreign key constraint fails
(`stw/bout_famille`, CONSTRAINT `FK_bout_famille_1` FOREIGN KEY (`id_fam`)
REFERENCES `bout_fam_car` (`car_id_fam`) ON DELETE CASCADE)

The error occurred in
C:\Inetpub\wwwroot\clients\STW\site_on_line\admin_ boutique\create_famille_save.c
fm: line 87

85 : insert into bout_famille
86 :
(apellation_fam,code_fam,description_fam,active_fa m,order_fam,famille_fam,speci
fique,date_crea,gestion_stock,elec_file,activity)
87 : values
('#form.fam_name#','#form.fam_code#','#form.fam_de s#',#act#,#next_order#,#parent
#,#spec#,#createodbcdate(now())#,#stock#,#felec#,# activity#)
88 : </cfquery>
89 :

Can someone help me, to make me understand how to create relationship inside
MySQL ?
Foreigh keys may be not the right way to create relationship ?
(so easy under Access and MSSqlServer)

Thanks for help,
Pierre.

[Dan Bracuk]

It sounds like you designed your database ok (not sure about the delete cascade
part though), but you are inserting your data in the wrong order. You have to
populate your parent table before you can populate your child table.