Hi,
I have a VS2008 VD Windows Forms application. I want the user to be able to add data about problems we encounter in the business. The problem has an ID, and within the problem there could be some quantities of units affected. So for example there could be
a problem which affects 5 pallets and 4 cases. Or it could be 4 cases and 2 bags. The user needs to pick the unit description from a list or similar so it remains consistent.
I've got a SQL Express DB set up with a one to many relationship enforced between the problem ID and the quantities table. So on a Windows Form the user can easily put the two quantities of "5" and "4" as in the first example.
What is the best way for them to add the units (cases, bags, etc) against each quantity?
Thanks in advance,
Steve