Trying to decide how best to go about this. The master list is a listing of many items, some of which are not inventoried? This being that we have the ones we want inventoried identified by a element (yes/no). We also have items in the list that are not including in the inventory because they are from a local distributor that are not of concern that wants them to be included in the weekly inventory. One thought was to create elements for store and date such that the information could be maintained for each item. As we work on this I am also trying to visualize how this is going to be presented to the user. When you mentioned user I also thought that it would be good to capture the user that performed the inventor for accountability.
Looking back at your post from earlier today you mentioned:
For reporting purposes I am wondering this table would allow reporting such that levels can be graphed over time to use for adjusting trigger levels used to determine if items need to be ordered. triggered levels are something that we would likely add in the future to assist in determining when levels reach a certain number than they need to be ordered and could create a report of those times below that level.
However, I only mention that as not to create scope creep but just to keep in mind. My main focus is just getting the core form so users are able to see a list of items for the day that they need to enter counts.
So back to the issue at hand, If I put a drop down which allows the user to enter the store then I could have the form only show the count and date for that particular store.
Looking back at your post from earlier today you mentioned:
6) make another related table where you update the stock balance value in main table with form php plugin. In this case you can have the history in the related table. Although inline edit straight in your main table would probably be more convenient for the user.
For reporting purposes I am wondering this table would allow reporting such that levels can be graphed over time to use for adjusting trigger levels used to determine if items need to be ordered. triggered levels are something that we would likely add in the future to assist in determining when levels reach a certain number than they need to be ordered and could create a report of those times below that level.
However, I only mention that as not to create scope creep but just to keep in mind. My main focus is just getting the core form so users are able to see a list of items for the day that they need to enter counts.
So back to the issue at hand, If I put a drop down which allows the user to enter the store then I could have the form only show the count and date for that particular store.