2 fields in group heading

Knack Community
1

I have a Contacts table that stores the organization name and phone number.
I have a Contacts table that stores contact information.

Contacts and Organization tables are connected.

In Contacts I have a dropdown so the user can select an existing Organization.
The Contact table grid is grouped by Organization.

So it looks like this:
ABC Trucking
Joe Smith
Al Jones
XYZ Corp
Pete Randle
Henry King

I would like the group header to contain the Organization and the Organizations Phone nnumber so it looks like this:
ABC Trucking (555) 767-9898
Joe Smith
Al Jones
XYZ Corp (555) 545-3333
Pete Randle
Henry King

2

Ed

See 1 of Carl’s tutorials on concatenation such as https://forums.knack.com/t/combine-fields-to-make-a-unique-record/11824**strong text** .

Dean

1 Like
3

Got it!
Fixed it.
Thanks.