Hi,
I have three sql tables, software, employees and AccesToSoftware. I need to do a view wich allow manager to give software access to the members of his team. I've got three SMO, one for employees (ID, name), one for software (ID, name) and one composite for access (ID, ID employee, ID Software, referal profil). When the manager give access to a software he has to specify the referant profil (a user that has already access to). I want to create a checkboxlist contains all our software, and when the manager checked an item a picker appear next to the selected check box to select the referant profil. A validate button insert the information in SQL table AccessToSoftaware.I don't think it's possible but if you have any ideas it would be great.
Thanks