Hi,
I have master list called "Products"
|
ID |
ProductName |
| 1 |
xxxxxx |
| 2 |
yyyyyy |
| 3 |
zzzzzz |
and i have another list called "Access Control"
| ID |
UserName |
Products |
| 1 |
John |
xxxxxx;yyyyyy |
| 2 |
Ebi |
xxxxxx;zzzzzz |
| 3 |
Mike |
yyyyyy;zzzzzz |
| 4 |
Jim |
All Products |
1. Whenever the user logged in , The InfoPath dropdown populate the product names against the user which is in the “Access Control List”for example,
1. If I logged in as “John” the dropdown has to populate the products against john
xxxxxx
yyyyyy
2. If I logged in as “Ebi” the dropdown has to populate the products against Ebi
xxxxxx
zzzzzz
3. If I logged in as “Jim” the dropdown has to populate all the products
xxxxxx
yyyyyy
zzzzzzz
Note:Using Out of box only