How can i Filter data so that users can only see certain information from the same database? Basically we are planning to use my product to send to different companies.. however we only want the Admins & Reps from those companies to only see their own companies fields and data. Is this possible? help is much needed :) thanks

I have an in web browser LightSwitch app and in one of the fields I have a date. I ran an update in the database to change some of the dates for some of the customers by ID number in the database; Update dbo.PatientStatusSet SET DateRecorded = '05/11/2012' where id in('983','1423','1621','3157','3563','4190','4455','4641','4642','4643','4644','4645','4646','4647','4648','4649','4650','4651') Now when I go back to pull up the customer database side, it shows the right date... but when I look at a particular customer app side, it shows the wrong date. Why is this happening? I've refreshed the browser and I even reset the browser (I'm using IE) but it still shows the wrong date. Thanks in advance!Russ, MCSE

Hi Everybody I have one entity called Product. And another entity called AssignLocation. The relationship between Product and AssignLocation is One to Many. (A Product can have many AssignLocation, An AssignLocation must have a Location). Please see the image below. My requirement is I want to filter products based on Location at the time of creation of Order.When I select a Location from Order the related Products for that location should filter in OrderDetails. Please see the image below for more detail Relationships An Order must have a Location. An Order can have many OrderDetails An OrderDetails must have a Product. Any help will be highly appreciated. ThanksRashmi Ranjan Panigrahi

Hi, I develop on windows xp service pack 3 with visual studio 2010 and lightswitch 11. I have this code:      Dim file As IO.FileInfo = Nothing             ' OpenFileDialog() must be opened on the UI thread             Dispatchers.Main.Invoke(Sub()                                         Dim dlg As New System.Windows.Controls.OpenFileDialog                                         dlg.Filter = "File XLS, XML|*.xls; *.xml"                                         If dlg.ShowDialog = True Then                              

I have a query that returns three values for use in an AutoCompleteBox. The values are: PressureLow PressureMed Pressure_Hi In my query I have it set to sort Ascending. But the AutoCompleteBox displays it in the order Pressure_Hi PressureLow PressureMed I specifically put the underscore in so that it would sort correctly according to the ASCII Sort Order. It looks as though Lightswitch does not follow this order. Does anyone know what the sort order is for Lightswitch queries?