AnsweredAssumed Answered

Restricted Found Set

Question asked by JimMac on Aug 2, 2012
Latest reply on Aug 23, 2012 by philmodjunk


Restricted Found Set


I want to restrict access to a Contacts table to AgentID's created records only and the managing Broker.  Agents should not have access to other Agent's contacts. The Contact table is password protected for each Agent.

now i have this...

AgentsID ----------<Contact::AgentID --------<Notes::AgentID and ContacID[unique and seq]

BrokerID -----------<Contact::BrokerID

Each agent must "copy" [actually just a non modidfiable field in each contact] each Contact to Broker with Timestamp of the copy to prove when the contact was made and alert the Broker.

I need to prevent AgentID =4 from seeing AgentID =9 contacts.

any thoughts?