Search results

Thanks Bob... so basically, what you are saying is that I could have a table with all the entitlements (there are over 200) with a yes/no option. For the ones selected they would change depending the selection. My question to you is how would I uncheck the entitlements based on the other list...

Thanks John... but it doesn't really help for my situation. I need to find a solution for moving items between the listboxes then updating tblSystemEntitlements. I am confused as how to link lboCurrentEnt with the table in order to update it. Any suggestions?

Okay... I have three tables... tblSystem Entitlements SE_ID SystemID EntitlmentID tblSystems SystemID System Name tblEntitlements EntitlementID EntitlementName I have a form with a combobox (cboSystems) which lists all the System Names which is pulling from tblSystems.. I have one...

Awesome... thanks a lot. I thought I had tried that initially... but I guess I didn't. You rock!

hello... I have two comboboxes... cboChoiceName is based on a query... when you select an item it populates cboChoiceSys. When you make a selection it populates lboEntitlements. My problem is when I change a selection in cboChoiceName, cboChoiceSys goes back to (0) and I can make a selection...

An example... employee X has access to system A. System A has these entitlements: Read Only Print Only Transfer Only However, the employee might only have Read Only. System B, however, has these entitlements: Outgoing Incoming Each system is unique. They are 3rd party systems which...

Okay... so I am working on building out a database that stores information for employees and their entitlements to different systems. Each system has different entitlements. I have created an Employee Table, System Table, and have consolidated table that had every entitlement possible...