I got it working yesterday, this is exactly what I needed. The only thing I didn't figure out was how to make the report from the Items table show up on the Focus table entry, which is ok. I believe it's because there is no relationship back to the items table, but I don't know if there is a way to create a relationship to that record via a quickbase formula field. When I tried to change the field type of the related focus table from a numeric reference to a numeric formula it broke the relationship between the tables. The only way I can think of doing it is through a dynamic form rule, but that doesn't help me for all of the existing records. But I guess I can grid edit and update those records, and rely on the form rule from there.
