Hi Folks, With the order Form created in Expert and Developer lessons. Is there a way to have the main form either add a new order or select an existing order? We raise blanket orders that cover a years worth of materials and we add the materials as and when requested through out the year to the Blanket Order. I would like to use the form to either create new orders as designed in the lessons but also have the option to add the materials (orderdetails) to an existing order.
Why not just create an order called "Blanket Order - June 2022" or whatever and then add items to that until it gets paid, then start another one? This seems more like a usage question than a design question.
Marc SpraggOP
@Reply 4 years ago
Hi Rick, sorry i haven't explained very clearly. I have a database where requestors add requests for the stuff that they want me to order. What i need to do is assign a corporate order to their requests but unfortunately it isn't as straight forward as just giving there request orderID a corporate order. The orderdetails determine how to assign the corporate order ie vendor, whos paying for the stuff etc. So I created a separate table SAPT (SAPID PK) so i can add the orderDetails into the SAPT as required. The form i use to do this works great. However now i need to also include SAPID's that are already created (BlanketOrders) so i can assign the order details to them. The Blanket orders are created at the beginning of each year and products would be are added as an when requested throughout the year. I was hoping to be able to capture this all in one form. I've attached a screenshot. Hopefully what im trying to do here makes sense.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 8.
