Crow Canyon Software Forum

Forum Navigation
Please or Register to create posts and topics.

Associated Column Query Builder.

I have 3 lists.

Table 1: (Issues)

Issue:  (Single line of Text)
_____________________

Table 2. (Issue Links) - A list that has numerous links for a single issue

Issue: Lookup (to Table 1 - Issues) - Issue)

__________________________

Table 3 (Staff Issues) - Staff  assiigned to certain issues (I want to display all the issue links for that specific issue. using an assuciated column)

staff (Person)

Issue ((to Table 1 - Issues) - Issue)

________________________

I have a nitro form on table #3. with an associated Column and trying to use the query builder to query all the issues form table 2 where the issues are equal.

I have tried numerous itteraitions but cannot figure out the correct syntax.

$parsefieldvalue(%%([Issue|Issue]%%,Value,;)
%%$parsefieldvalue([Issue|Issue],Value,;)%%
%%$parsefieldvalue([Issue|Issue])%%

Thanks for any help  with this.

 

Uploaded files:
  • Screenshot-2025-08-27-141702.png