Data Tag BAQ

Hi Everyone, I am new to using data tags. I would like to use them in a BAQ. My understanding is that I need to join the SysTag to the Table that contains the Data Tag, in this case JobHead. What is the relation to join them?

It looks like SysTag uses the foreign table name and the foreign sysrowid. Join the two tables on JobHead.SysRowID = SysTag.ForeignSysRowID. Then make sure to set the Foreign table criteria for SysTag to “JobHead”. We dont have any records there so I cant give you an example.

4 Likes

@NateS is correct.

1 Like

Thank you so much! Works perfectly and thanks for letting me know about the criteria. I would have never figured this out on my own. Thanks again!

1 Like