clockwork3orange
Member
- Joined
- Oct 20, 2006
- Messages
- 21
- Programming Experience
- Beginner
I'm trying to code a small application that basically manages non product PO's. In other words a front end to a access database that can create/edit/print/email...purchase orders. PO's essentially have some standard info on each such as a PO number, vendor name, date and so forth. They will also have 1 or more items purchased on each PO. So in its most basic form I would have two tables in a database 1 with the general PO information and another with the lines items and the PO number as a key to associate them to the general info. So if a user runs this program and they want to buy 5 items how do I create a front end in VB.NET 2010 express that will accommodate a different number of items each time? How would the update/add query look to the database to accommodate dynamic entries as well?