Skip to main content
Question

Cross Join between two tables

  • April 11, 2019
  • 0 replies
  • 42 views
Hi All, I have a requirement where i need to create a Time series chart (Heat map to capture future work) . So basically i have 5 activities( which are calculated based a date) to which i need to map to my projects table. I am not sure but i am actually looking for a Cross join between Projects table and Activities tables. so that i can create an expected chart. Is this achievable
    This topic has been closed for replies.

    Do you current have a relationship set up where 1 Project has Many activities.
    No , Currently activity is not is there in system yet .  The requirement is that each project should have 3 activities and  its start and completion dates (based on the date which is present in project table). I believe i should  create a new table where each project  in project table should have 3 activities and its dates in a new table based on that i will create a chart(I do not want to create duplicate entries for activities in  project table).  Kindly suggest. _
    Yes, you should have a Child table of Activities.  if you like you can set up an Automation to create the three standard Activities when a Project record is created.
    Terms & ConditionsAccessibility statement