Home > IT Answers > Database > master-detail forms
Ssecrist
5 pts.
 master-detail forms
Database, forms
In a master-detail form when I query the master it returns the data, then I query for the detail records and it returns the detail data. When I try to add a detail record the application is also trying to add the master. I only want the new detail record. The master already exist.

Software/Hardware used:
ASKED: May 22, 2009  6:23 PM
UPDATED: January 8, 2010  5:59 AM
RELATED QUESTIONS
Answer Wiki:
Before adding a record, you need to check if the record exist already. If it not, then only add it. Also if the current transaction is changing (or deleting) a master or detail record, the relevant record needs to be changed (or deleted) in the database. Hope this helps. Regards, JG
Last Wiki Answer Submitted:  January 8, 2010  5:59 am  by  Jgunja   1,165 pts.
All Answer Wiki Contributors:  Jgunja   1,165 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

You will need to specify at least what programming language and database you are using.

carlosdl
 63,580 pts.