Using the customer portal - The manager logs in ( using his email address as a login) - and is presented with a form to enter asset data. Within this form, by using deluge script ( on load) - I can identify which store etc. he belongs to,  which helps pre-populate the form called " Asset_Management" where data regarding the stores assets is entered.

IF the "asset data" information is entered by the store manager - I can create a report showing the asset information and restricting the data viewed to only that data entered by the store manager using the  criteria field on the report such as : "added user is login user" This works perfectly -  IF the store manager has entered the data.

However if someone else (like me as I populate the initial database) enters the data  - I am then shown as the "added_user" in that record -  and this previous criteria keeps the store manager from seeing the data that I entered when he looks at the report.

So ... I've been struggling for a method that would enable me to associate the currently logged in "login user" with his/hers store ID ( or something similar) so that no matter who enters the data for that particular store - as long as the data record contains the login users "store" - he's allowed to see all records in the report no matter who added them.

Any suggestions? ( I'm sure I'm just missing something obvious)

Much appreciated - Craig