Constraints created as All in roles

[Former Member]

I created 5 lookup table in Main table, 2 of the tables got created with constraints as ALL in Tables and Fields tab of Roles. Iam not sure how constriants got added to these tables. Can anyone help

[Former Member · Accepted solution]

Hi Aruna

For any newly created Lookup table ALL is added in constraints by default.

Please note that constraints can not be defined for multi valued Lookup tables. May be in your case the other 3 lookup tables are multi valued.

thanks-Ravi

[Former Member · Accepted solution]

Hi All

Problem is resolved. Thanks

Regards

Aruna

[Former Member · Accepted solution]

Hi Aruna

Pls also mark the thread as answered. Thanks-Ravi

[Former Member]

Hi Aruna,

Once you create and add data to lookup table in role option constraint will display ALL by default

Constraint option will allow you display only specific value to the user for e.g in your lookup table has value A,B,C,D,E,F and in role constraint option you have select A,B value so in data manager user will able to see only A,B value, and if you set ALL will display A,B,C,D,E,F value

Hope it will resolved your problem if not revert back

Thanks,

Jignesh Patel

Edited by: jignesh patel on Aug 11, 2010 12:38 PM

[Former Member]

Hi ,

You cannot do changes in Admin role.

Just create a new role and go to the Table and fields tab

In the constraints coloumn, select the cell where [ALL] is showing and click on the dropdown .

It open a popup with Available Values and selected Values

Move the values from left to right if you want that this roles see only those values.

Do the same thing for all lookups.

Assign this role to user

and try to login in DM with that new user ,you will see only those values.

Try at yrt end and get back with ypur results.

Thanks,

Sudhanshu