Home » Developer & Programmer » Forms » how to give access to different logins ,on records
how to give access to different logins ,on records [message #258538] Mon, 13 August 2007 00:33 Go to next message
sams
Messages: 100
Registered: August 2007
Senior Member
For Attendance system (student's attendance is entered subjectwise) , whenever teacher logins to system ,i want to give her access to only those subjects which she teaches.

Means that she is allowed to enter attendance of only those subjects which she teaches.
Subjects that teacher teaches are placed in table named 'Teacher_subject'.

can somebody tell me how to do this.
thnks

[Updated on: Mon, 13 August 2007 00:34]

Report message to a moderator

Re: how to give access to different logins ,on records [message #258569 is a reply to message #258538] Mon, 13 August 2007 01:49 Go to previous messageGo to next message
azamkhan
Messages: 557
Registered: August 2005
Senior Member
apply a where clause in your block property...
Re: how to give access to different logins ,on records [message #258589 is a reply to message #258569] Mon, 13 August 2007 02:15 Go to previous message
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
You might also check what Virtual Private Database is.
Previous Topic: hierarchical tree
Next Topic: Database procedure or Forms procedure
Goto Forum:
  


Current Time: Fri Sep 27 04:25:34 CDT 2024