USE [Users_mdb]
GO

/*** Workflow for hiding Teacher and Student fields to others ****/
IF EXISTS (SELECT * FROM [dbo].[tblPossibleValue] WHERE [nID]=60 AND [nRuleID]=60)
	UPDATE [dbo].[tblPossibleValue] SET [tValue]=N'155;70;69;72;71' WHERE [nID]=60 AND [nRuleID]=60;
GO
	
IF EXISTS (SELECT * FROM [dbo].[tblPossibleValue] WHERE [nID]=66 AND [nRuleID]=66)
	UPDATE [dbo].[tblPossibleValue] SET [tValue]=N'155;287;137' WHERE [nID]=66 AND [nRuleID]=66;
GO

IF EXISTS (SELECT * FROM [dbo].[tblPossibleValue] WHERE [nID]=67 AND [nRuleID]=67)
	UPDATE [dbo].[tblPossibleValue] SET [tValue]=N'154;70;69;72;71' WHERE [nID]=67 AND [nRuleID]=67;
GO

