First - Sorry if I'm putting this thread in a forum where it would best suit somewhere else.
I have 2 months experience now doing web-development using PowerBuilder, the EAF framework, and JSP. I have a datawindow that performs an insert on data inputted by the user. The insert fails due to the Oracle error in the thread subject. I have an employee table with employee_id as the PK. I have a table called EmployeeDiscipline listing items by employee whose PK is also employee_id.
I understand the error, but the employee_id exists in the employee table before inserting into the Discipline table so the FK exists. Anyone have any suggestions?
I have 2 months experience now doing web-development using PowerBuilder, the EAF framework, and JSP. I have a datawindow that performs an insert on data inputted by the user. The insert fails due to the Oracle error in the thread subject. I have an employee table with employee_id as the PK. I have a table called EmployeeDiscipline listing items by employee whose PK is also employee_id.
I understand the error, but the employee_id exists in the employee table before inserting into the Discipline table so the FK exists. Anyone have any suggestions?