JuniorData
MIS
I have a main form that has a combo box for choosing customer, and two sub forms (both sub of the main form). sub1 is a continuous form, no additions, of existing orders for that customer. sub2 is the details of each order (it shows which budgets each order comes out of). sub1 has an 'on current' that dictates what shows in sub2. These sub forms use filters to show the appropriate records.
My question, what would be, in your expert opinions, the best way to handle adding new orders? We need to add an order and it's budget breakdown.
I've considered an 'add new' button that changes the sub forms to allow additions but had problems with applying the order to the correct customer without having to choose the customer again in sub1.
The other idea is for the 'add new' to open another form dedicated to adding orders.
I have sub1 and sub2 arranged the way they are because the DB owners wanted their data entry person to be able to make changes to existing orders.
Can anyone offer opinions on the best method? Does everyone like the Northwind 'orders' form? Should I follow that model with the addition of sub2?
Any wisdom you can offer is appreciated!
My question, what would be, in your expert opinions, the best way to handle adding new orders? We need to add an order and it's budget breakdown.
I've considered an 'add new' button that changes the sub forms to allow additions but had problems with applying the order to the correct customer without having to choose the customer again in sub1.
The other idea is for the 'add new' to open another form dedicated to adding orders.
I have sub1 and sub2 arranged the way they are because the DB owners wanted their data entry person to be able to make changes to existing orders.
Can anyone offer opinions on the best method? Does everyone like the Northwind 'orders' form? Should I follow that model with the addition of sub2?
Any wisdom you can offer is appreciated!
