I am developing a point of sale (POS) for a pharmacy. I have not managed to extract again information for a cancellation receipt. This is because the receipt generated for the sale could have had different discounts to today’s date, so it is required to show the information of a sales receipt of that sell date to a form with a new receipt (generate the new receipt and select the receipt to be canceled has already been achieved using a Reference) but it has not been possible to show the list of that sales receipt in order to modify the cancellation of the product or products with the price of that date.
I am currently using the following:
Tables: Orders (General characteristics of receipt) and Order Details (Products related to Order sell)
I have tried select, list, filter but this does not bring it back to the form of related products.
So it goes like this:
1.-Add Order: Generates the new Order Receipt UniqueID
2.-select Transaction Type: Sell or Cancel
3.-If Cancel show Reference and select Sell Receipt UniqueID
Case–>4.-When selecting Sold Receipt display the related list of products for that Reference that should belong to the Sold Receipt and make them editable to leave the products to be cancelled
5. Continue Order Form and generate the Order Id
I am new at this so I have to explain it as a mortal.