i have a query that makes a new table and renames (to that systems id, system#xxx_qty&loc) it when a new system is added. the new table tracks the quantities and location of parts for that new system, each system is unique. i also have a table (system id) that has a single feild that identifies...
thanks for your quick reply
i have my tables split already as you recomended. what i dont have is the quantities set up.
ok to answer your counter questions
main inventory on sharepoint.
Do you mean that your Datebase Back End is on Sharepoint, or that the main Database is stored there, and...
ok this is about to turn my grey hair blue.
what i have is this situation. how to track inventory consumption from multiple remote users reporting to a single place on sharepoint. operations managers need to be able to view usage and status of each remote user.
1. main inventory on sharepoint...