Forum Discussion
DonLarson
Qrew Commander
Evan,
Consider putting a child table in between the Employees and Tasks
Tasks << Employee Tasks >> Employees
Now you can add as many Electricians to the Task as you need. Also you can get business process info on each individually. Maybe both start the task day one, but their is only one there on day two to complete it. You know now who was assigned and who finished.
------------------------------
Don Larson
------------------------------
Consider putting a child table in between the Employees and Tasks
Tasks << Employee Tasks >> Employees
Now you can add as many Electricians to the Task as you need. Also you can get business process info on each individually. Maybe both start the task day one, but their is only one there on day two to complete it. You know now who was assigned and who finished.
------------------------------
Don Larson
------------------------------
EvanMartinez
5 years agoQrew Elite
Hi Evan,
I would agree with Don's suggest that if you want to be able to attach multiple Employees and Tasks an Employee Tasks table is a great way to manage that. That way they would all appear on an embedded report in the Tasks table or Employees table with all the combinations and going forward you could use that for reporting as well using the relationships.
------------------------------
Evan Martinez
Community Marketing Manager
Quick Base
------------------------------
I would agree with Don's suggest that if you want to be able to attach multiple Employees and Tasks an Employee Tasks table is a great way to manage that. That way they would all appear on an embedded report in the Tasks table or Employees table with all the combinations and going forward you could use that for reporting as well using the relationships.
------------------------------
Evan Martinez
Community Marketing Manager
Quick Base
------------------------------