Using a Listbox to allow Users Access

2009-09-28 Thread Damo Drumm
Hi, I have a drop down list on a form showing a list of Companies, which ive linked to a table called Company, Im trying to use this list to give access for each username, at them min when someones name is added to the Table (Users) they have access to all Companies on the list box, im trying

Re: Using a Listbox to allow Users Access

2009-09-28 Thread Randy Adkins
Depending on how you have your validation structured for permissions, an idea would be: Session.CompanyAccess = '1,2,5,6' Then you can validate it when needed. Now if you are going further to set permissions such as CRUD: Session.CompanyAccess.Permissions_1 = C,R,U,D

Re: Using a Listbox to allow Users Access

2009-09-28 Thread Damo Drumm
Thanks, The first option will suit me so if i set up a field in My Users table called CompanyAccess, then followed by the correct code it will be able to pick out wheather or not I can access it depending which numbers I have entered in my CompanyAccess field Depending on how you have your

Re: Using a Listbox to allow Users Access

2009-09-28 Thread Randy Adkins
Yes, however you will need to validate permissions when needed Ex: CFIF ListFind(Session.companyAccess,thisCompanyID) ... GOOD CFELSE ... BAD /CFIF On Mon, Sep 28, 2009 at 7:14 AM, Damo Drumm damien.dr...@quinn-group.comwrote: Thanks, The first option will suit me so if i set up a field