Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

I am still having problems

Status
Not open for further replies.

chidi

Technical User
Mar 24, 2003
42
NG
I have been trying now for the longest to insert records into detail form in a master/detail relationship.
I want to be able to:
1, insert and save records in a detail block.
2, I also will like to pull specific records into detail block from master block.
I have not been able to accomplish any of these.
I keep getting error frm-40508: Unable to insert records.I don't know what is wrong.
There are some non-database items on detail block but on the property's window, I have changed them to query - no, insert - no, database item - no.
Please help!
 
Create an ON-ERROR trigger and in that make a call to DISPLAY_ERROR;. That way you will be able to see the exact INSERT statement the form is attempting to run.
 
Thanks lewisp!
I solved it!
I went to Metalink and was able to see (just you said) the exact error, corrected it and now I am happy.
Thanks for helping a lot of people like me.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top