The developer column in Table 2 has a relation done with the above table (Table 1) but I can’t figure out how to do the following:
*Selecting 1 name to add all entries from table 1 under that name (in stead of doing multiselect for all rows in table 1)
Sprint column in table 2: this one also is a lookup function from table 1, but I would like to make it a drop down menu where I can select between the sprints. *
Right now i see that the Sprint column is bound by what I select in the developer column. But I want to be able to divide this view example:
Alex to have his entry in Sprint 12 the first bracket and then Sprint 13 the middle bracket of grouping.
If something is not clear in my question or you need more details, please let me know. Otherwise would appreciate your help here as ive been stuck with this for 2 days and can’t figure it out at all
Here you don’t only have tasks, but estimations and worked hours per developer. Those are different business objects and in my opinion they should be split in different tables.
Once you’ve done that, it will be much easier to build your summary table.