Its an apparel business. So there are many articles with different colors and sizes.
I receive orders with different articles and sizes and colors.
1) I need a form where i can input the order. I click “submit” at the end and it should subtract all inventory from the final inventory sheet.
2) there should be a record of each order i create.
3) i should be able to add new articles with color and size variations and their opening inventory.
4) the final inventory sheet should reflect current inventory in each item’s color and size.
Most of the work is already done. I have the file. But the problem is there is no parent/child relationship between the colors and sizes.
This is the most important thing in managing an apparel based inventory system.
The product should be the parent item. Then the colors should be the children and the sizes in each color the sub children.
This is essential for managing the database.
If you have the expertise to deal with this work, have a look at the attached access file.
4 фрилансеров(-а) в среднем готовы выполнить эту работу за $57
Good Day, Please contact me at Skype [login to view URL] Relevant Skills and Experience I am working as MS Access Programmer for 8 years. I can give you a good outcome.