The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
I decided at one point to create an extra table to keep some additional records related to another table. What I did is to create a new table and add a column linking to the original table. So there is supposed to be a 1-1 relationship between the ro...
I am trying to figure out how to have two columns in some sort of table or report where one is drawn from one table and another is matched according to an aggregate on another table. In SQL, this would roughly look like
SELECT a.name, a.target, sum(b...
I see now that something like this is possible by linking from TAB1 to TAB2 and then adding a rollup field.
This works but it requires manually linking the two tables. This seems a mind-boggling omission in that there is no way I can see to link the ...