normilization with a twist

[hyperionfall]

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.
2. multiple usres in the feild.(consumers) update to share point.
3. ops managers at main office. (live conection to sharepoint)
4. remote users may not have live connection all the time to sharepoint but will be able to update on regular basis(24 hour window).


5. new remote user must be able to install (control panel/back end) without being able to edit tables or forms.
6. ops manager must be able to see specific data for each remote user.

my main issue is how to set up data modeling and normilization to include 50 + and growing users consuming 1000s of different parts. i need to track quantity on hand, on order quantity, back order quantity etc.. for each part on their system. everyway i have treid will excede 255 columns in a table. if i columnize by systems aand put the part in rows it will exceede 250, and there are 1000s of parts so cant columnize that. tried looking at unique table for each remote user but i have the issue of how to autogenerate the table in the remote users app and then linking it to sharepopint (remote users will have no access to design features). i seem to end up chasing my own tail every direction i go.
could some nice person please help out a rookie here.


thanks,

lee

[NTC]

strikes me as too big a topic for a forum, or a novice (no offense) - you might want to look around in your area for a database person for aid......

[hyperionfall]

no offense taken

[hyperionfall]

git it figured out