Foreign Key Violation


#1

I have a 3 tables.

Menus
Application_Roles
Menu_Roles

Menus table is having many-many relationship with Application_Roles
table and is linked via join table, Menu_Roles.

I have 2 drop down in Menu_Roles view html. The values of these 2 drop
downs are populated using “select” from Menus and Application_Roles
table. I could see the id and the description populated in the drop
down from these two tables. But when I try to save it (i.e. create a
record) to Menu_Roles table, I get foreign key violation with values 0,
0 selected (error messages shows the value selected are 0 and 0).

any help is greatly appreciated.