VS 2008 Relational Database Entries

[Specialt1212]

Thank you for the response, but I'm not sure if I understand 100%

Here's an image of all the DataTables and DataRelations within my Dataset.



And here is a picture of how i step up the original application



I can add an employee to the datatable for example

EmployeeID: 4
EmployeeFirstName: John
EmployeeLastName: Test

Then if I click the save button it will save the new record and then I can manually add records to the joint tables showing what computers & Software John Test has access too. This option works great without any issues.

Now lets just say I wanted to enter data in a different manor and for simplicities sake lets just say each employee can only have two type of Software & two types of Computers like seen in the example below.



Could I have a setup like the image shown above where the user would enter only the Employee ID, First Name, Last Name, Software Name 1 & 2, and Computer Name 1 & 2 and have the joint tables auto update based on the information input in the fields?

If I'm not explaining myself clearly please let me know and I'll try and go into more detail. Thank you for the help!