2. PHPRunner General questions
  3. Help building query
This topic is locked

Help building query

 		2/23/2007 12:51:33 AM
PHPRunner General questions
G
 gdude66 author

I am trying to build a query which chooses reults from 1 table based on a field on the logged in users table.

eg

table event

fields id, studentcode, form, description, time lodged
other table staff

field to cross check is homegroup
What I want is for the page to build only those students whose 'event'.'form' = 'staff'.'homegroup'
so if the logged in user has 10b as their home group only student events for form being 10B will be filled.
Can this be done? This way I don't have to use ACLs
G
 		gdude66 author 2/26/2007

sorry but bump - really need help here
J
 		Jane 2/26/2007

Graeme,
use User can see and edit their own records only option on the Advanced security settings dialog on the Security tab and select form as Main Table: OwnerID, homegroup as User Table: OwnerID.
G
 		gdude66 author 2/26/2007

Graeme,

use User can see and edit their own records only option on the Advanced security settings dialog on the Security tab and select form as Main Table: OwnerID, homegroup as User Table: OwnerID.



Thank you Jane.

That was too easy - I was complicating it with sql statements with where connectors etc.

Gotta love the support here.