Hello, I created a simple database that has 3 tables & 2 joint tables for data entry purposes.

The tables & fields are listed below. All items that appear in red are the primary keys

Employee
EmployeeID
- FirstName
- LastName

Software
SoftwareID
- SoftwareName

Computer
ComputerID
- ComputerTypes

JtblEmployeeSoftware
EmployeeID
SoftwareID


JtblEmployeeComputer
EmployeeID
ComputerID


I had no problem creating the database or adding it as a datasource but now I need to figure out how to add data to all the individual tables without having to remember the assigned ID field for each table entry. This is a really basic example of what I would like to do but I'm trying to figure out the basics first before I doing anything else on a larger scale.

Ideally for this example I would like to have textboxes for the Employee First / Last name as well as a datagridview to enter Computer & Software information since they may have multiple computers and software applications. And I was hoping to avoid having to manually enter data in the joint table. Is that possible to do or will I be required to enter relational data in the joint tables?

I've include the source so you can look at it in case that will help make more sense.

Download Link - http://www.mediafire.com/?jnbwetbm0bt