first of all I want to introduce myself.
My name is Nunzio, living Germany and I'm going to realize my first Project in Lightswitch with a Silverlight client. Unfortunately I have a problem which I'm not able to solve it alone.
I have two entities on a given SQL Database (Addresses and Customer Data). These are linked as 1 Address to n Customer Data. So in theory it's possible to have more than one customer account for an address. But practical we don't use this. Now I have created a Silverlight Screen with editable grid for addresses and in the bottom there will be shown the customer data for the selected address. In the customer entity is an information about the assigned sales representative to the customer. I want to have the possibility to filter the addresses for this sales representative. So when I make a choice the address list should show by example only my own related addresses.
Can anyone please give me an advice how to realize that.
Thank you in advance.