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]
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.