I'm working on a design for a project that has the following requirements and I need to see how SF "User File" system can work into this situation:



a) The project is supposed to work for a company that has several remote stores.

b) Each store has it's own users, sales persons, customers, sales records.

c) All these stores will be using one common inventory, one order/item files for sales. So basically all these stores’ inventory, sales and other files are stored within one database.

d) Each user needs to be under a particular store. So, store # will be the parent of each user. Which means, when a user is being created, first the Store # must be selected and then the user, to have the store # as it's parent.

e) When a user logs in, the program, will look at the store # of the user and will limit all the customers, sales persons for that store. This way, I can logically separate each store from others.



Seeing that SF uses it's own program and data files to create users, permissions, roles and etc. and I need to attach a store # as part of User record, how can I incorporate Store # into user system? This way, I can look at the logged in user and get the Store # and take it from there.



Could you please tell me what my options are, without disturbing the flow of SF security system and still be able to use store as parent.



Thank you in advance!

..ßen