I also did this using a DataView wp and used the LOGON_USER server variable as a filter. I think this method is a little more secure because you can add it to a page, rather than the actual list form view.
From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Paul Noone Sent: Monday, 13 February 2012 10:27 AM To: 'ozMOSS' Subject: RE: SharePoint Online Create an account for each user and pass in a unique property. Then use the Current User Filter, select that property and connect the web part to the list view. This is only a filter though and will not stop them from seeing other customer info if they're smart. From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Ajay Sent: Friday, 10 February 2012 5:02 PM To: ozMOSS Subject: SharePoint Online Hi Guys, I am talking to client to display customers order data from ERP to SharePoint online. The orders table has about 15 customers. I am planning to pull data from ERP to SharePoint list. If all data is in a single list, what's the best way filter data so when each of the customer logs in, they see only their orders. I am thinking to add customers accounts as extranet users, but can also add them as normal users also if it helps. Is there any way, by which I can identify customers with their orders. I am looking at the Additional details when we create a new user, can I add the customer name in the department column and then when people login use the company name stored in the user settings to filter with company name in the SharePoint list. Another option: Create 15 create lists one for each customer and remove inheritance and grant permissions. Cons:- I will have 15 lists to synchronize and set up 15 views in ERP, so lot of work.
_______________________________________________ ozmoss mailing list ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss