PRAISE PHS
Well-known member
- Joined
- Jun 2, 2011
- Messages
- 58
- Programming Experience
- Beginner
Hi All,
Pls kindly help me out on this programming logic:
I'm designing an inventory management app. I have three child windows on a parent window. The windows are Products, Stock-In and Stock-Out. The product form stores product details, stock-in stores details for items coming into the store and stock-out stores items going out of the store. There is a combo box in the stock-out form that is filled with the Item Name and ItemID. When I select the item name, it populate another combo box with the item serial no. then i select a serial no which is then displayed on a listbox. i want it that any serial no selected and displayed on the list box should not be available again for selection. i have a field called availability with a default value of 1 in my DB. the field is in my serial no DB table. also i want the remaining stock to be reduced anytime i select the serial no. pls kindly help.
Pls kindly help me out on this programming logic:
I'm designing an inventory management app. I have three child windows on a parent window. The windows are Products, Stock-In and Stock-Out. The product form stores product details, stock-in stores details for items coming into the store and stock-out stores items going out of the store. There is a combo box in the stock-out form that is filled with the Item Name and ItemID. When I select the item name, it populate another combo box with the item serial no. then i select a serial no which is then displayed on a listbox. i want it that any serial no selected and displayed on the list box should not be available again for selection. i have a field called availability with a default value of 1 in my DB. the field is in my serial no DB table. also i want the remaining stock to be reduced anytime i select the serial no. pls kindly help.
