Adding to the many side of the DB.

Posted on 2011-04-24
Last Modified: 2012-06-27
in visual studio, i created 2 tabs, first is one that will enter the main info about an employee 'the one side, being EMPID IS PK' and another tab to enter information about the employees 'the many side EMPID IS THE FK' I used the binding navig. in both tabs each bound to its relative table, yet, in the second tab i cannot add new because obviously a related record is require in the first tab 'tabs ar not the issue here' so i tried making a combobox in the second tab 'many side' that contains the text list of the EMPID in the one side so no non-existing PK from the one side can be entered, but on saving, it says 'an update query is required.....etc' so is there a way to get around this?
Question by:ahashash
    LVL 83

    Expert Comment

    Did you use the wizard to create the data objects?

    Author Comment

    yep, i  did.
    if there is a place or a book i can buy that can assist me in these issues i wud be thankful for u guys, i love to learn on my own some of those great tips and tricks.
    LVL 83

    Accepted Solution

    Dont know about books but try this tutorial

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Suggested Solutions

    Microsoft Reports are based on a report definition, which is an XML file that describes data and layout for the report, with a different extension. You can create a client-side report definition language (*.rdlc) file with Visual Studio, and build g…
    Here is a helpful source code for C++ Builder programmers that allows you to manage and manipulate HTML content from C++ code, while also handling HTML events like onclick, onmouseover, ... Some objects defined and used in this source include: …
    THe viewer will learn how to use NetBeans IDE 8.0 for Windows to perform CRUD operations on a MySql database.
    The viewer will learn how to synchronize PHP projects with a remote server in NetBeans IDE 8.0 for Windows.

    730 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now