+ Start a Discussion
bhanu_prakashbhanu_prakash 

Assigned record to users

Hi team,

I have 3 custom objects Work__c, Team_Work__C, Work_Task__C and User__c

User__C object has Name
Work__c object has Name, Time
Team_Work__c has Work_Name (lookup to Work), User_Name(lookup to User),Role_of_work (picklist)
work_Tasks__c has Assigned_To__C, Status__c, Work (lookup to Work)

Now iam creating a work_Tasks__c 

I need to create a work record 

1. Work : Car have issue
   time : 2:00Pm
 
Then i will assign it with Team_Work__c  
Role_of_work : Picklist contains (Manager, Supervisor, technical)
 2. Team_Work__c_id : auto Number
      Work_Name     : car have issue (lookup to work)
      User_Name     : Test
      Role_of_work  : Manager 

 2. Team_Work__c_id : auto Number
      Work_Name     : car have issue (lookup to work)
      User_Name     : Test1
      Role_of_work  : Supervisor 
 2. Team_Work__c_id : auto Number
      Work_Name     : car have issue (lookup to work)
      User_Name     : Test2
      Role_of_work  : technical 
 2. Team_Work__c_id : auto Number
      Work_Name     : car have issue (lookup to work)
      User_Name     : Test3
      Role_of_work  : technical 

NOte:  it have 1 Manager(only) and 1 Supervisor need to be for each Team Work record.

Now iam trying to Work_Task__C task 

work_Tasks__c has Status__c, Assigned_To__C, Work (lookup) 
Status__c    : New, in hold, urgent
 
  3.  Work :  Car have issue
      Status :  New 
      Assigned : Test  (need to assign test because he is Manager)

      Status :  in hold 
      Assigned : Test1 (need to assign test1 because he is Supervisor)

      Status :  urgent 
      Assigned : Test2/test3  (need to assign test2/test3  because he is technical)

Thanks for advance