Alright, so I got a very unique issue. It combines a little bit of SQL, VB.net Skill, and patience. The program I am trying to make needs to be structured like this.
Table 1: Estimates (Details View)
Customer ID
Employee ID
Form Factor
Problem
Proposed Solution
Estimate Acceptance (Boolean)
Table 2: PartsList (Grid View)
Part Number
Part Name
Part Cost
Now, the trick is, I need to have it where each Estimate can have its own individual parts list. It needs to be this was as each estimate could have just one part, or many parts. How can I do this effectively? I already have the tables and the layout of the app, I just need to get it all connected up. Thanks!!!