master-detail forms

5 pts.
Tags:
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.

Answer Wiki

Thanks. We'll let you know when a new response is added.

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

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • carlosdl
    You will need to specify at least what programming language and database you are using.
    70,220 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following