Hello All -
I am trying to develop an application that can track sales.
Background: We supply different construction-related products to various contractors. There are a max of 50 items in our inventory. And every sale may have 3-4 products at most. I would like to be able to have a record of (i) who the items was supplied to, (ii) date of request, (iii) date of delivery, and importantly (iv) what was supplied per transaction.
I am imagining something like this. Have dropdown menu for contractor list and two listboxes. One listbox will include all items in our inventory and the second listbox will display all items supplied. By double-clicking on the items supplied (in the first listbox), the second listbox will be populated. This information will be displayed in the second listbox per transcation. Is this a good way? How do I store this information per transaction? Please share your comments or suggestions.
Also, please free to suggest ideas that can be simple and easy to accomplish.
I am not a MS Access guy by any means. My knowledge is rudimentary.
Thank you.
I am trying to develop an application that can track sales.
Background: We supply different construction-related products to various contractors. There are a max of 50 items in our inventory. And every sale may have 3-4 products at most. I would like to be able to have a record of (i) who the items was supplied to, (ii) date of request, (iii) date of delivery, and importantly (iv) what was supplied per transaction.
I am imagining something like this. Have dropdown menu for contractor list and two listboxes. One listbox will include all items in our inventory and the second listbox will display all items supplied. By double-clicking on the items supplied (in the first listbox), the second listbox will be populated. This information will be displayed in the second listbox per transcation. Is this a good way? How do I store this information per transaction? Please share your comments or suggestions.
Also, please free to suggest ideas that can be simple and easy to accomplish.
I am not a MS Access guy by any means. My knowledge is rudimentary.
Thank you.