Forum Discussion

Qrew Member

3 years ago

Pulling Data up from several tables deep to report

Ok, I know this should be possible...I have an App with 9 tables in it. This app is functioning as a Master Staff List, and also HR Database with Staff Assignments, pay, etc in it. Brief Descript...

AllissaWeber1

Qrew Member

Thanks Mark, that did work.

Now, I have another question. Is there any way to only pull the ACTIVE record in the Staff Assignments table? The combined summary is pulling all instances of Team Names that are active in the employees past records (in Staff Assignment Table). Example below.

I also learned where the original version of the Relationship Diagram is! ;o)

------------------------------
Allissa Weber
------------------------------

MarkShnier__You

Qrew Legend

3 years ago

np,
Like any Summary field, the Combined Text Summary field properties can be configured with a filter. So just add the filter where the [Assignment Status is Active].

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------