I am creating a warehouse management app and I have run into an issue. Any help or input would be much appreciated!
The screen above is where I am running into an issue. All the radio buttons represent a table.
The labels underneath is an edit form that is filled in with the selected item in anyone of the tables. My issue is I need the move button in the right corner to "OnSelect" move the record that is selected to the table that is indicated by the drop down list. I also need the capability to move a specified amount of quantity from a record. This would be changed in the edit form. So that if I only want to move half of what is in shipping to receiving the quantity would subtract from the receiving and add to the shipping.
I believe that the "UpdateIf" function will be of use here but I am struggling finding a solution. Let me know what anyone thinks and if you need more information.