|
-
Jun 27th, 2010, 09:19 PM
#1
Thread Starter
Member
VS 2008 Relational Database Entries
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|