This question stems from a long series of questions involving a Custom Help Desk created in Excel. The link is below. The most recent addition to this was an incredible search function which finds and identifies individual item numbers by their respected vendors. In this question, I am attempting to create a similar process, but for identifying purchase orders and its attributes.
I have a database which contains a table with the purchase orders and all attributes for each. This database is also linked to an Oracle database that will update the local table. Each purchase order involves only one vendor. Each purchase order line contains only one specific item. The goal now is to allow the user to search for the purchase order and send requests to have specific attributes updated or have the line cancelled altogether.
Basically, the intent is to copy an existing process that involves items and have it involve purchase orders.
Cancel PO Line
-Must choose PO Number and identify line number.
This is bare bones in its development phase so I am quite certain there are a lot of gaps in my descriptions of this new module. I am open to suggestions concerning design and functionality. Once again, I sincerely appreciate the help.