Sure In salesforce there is a table Orders that has the fields account, Order number etc… There is also a linked one to Many relationship to the Order Product (we renamed it to Order Item) table that has Order Number and Order Item (Sku).
The main goal is to have something like the following:
So the user can enter one or both fields and get results that contain orders that match.
Any clearer?
