i m facing a problem in master detail form.i have master record table and its detail record table respectively.
in master table fields are:h_id(primary key),name,skills.
in detail table fields are :h_id(primary key of master table i.e foreign key),t_name,comments.
the problem is:
when i try to insert record in both table,first time record entry is perfect.
for e.g in master table record is as follows:
in detail table record is as follows:
it will insert the record,but second time when i try to insert another detail record for the same entry of master record,it display an error message :::: unable to insert.
can anybody tell me how to insert multiple detail records for a single entry of master recod.
As it is a Forms question, perhaps you should - once the error raises - go to Help menu and select "Display error". It should tell you exact reason (including ORA-xxxxx error code). If you don't know how to solve it, please, post the information you have found.