Reference Tables & Keys Hello Community: When referencing tables together, does one of the columns need to be a key? Or as long as values are identical, they can reference each other and pull child fields into the parent table?
My question may not make any sense, so here’s my goal: Table 1 [Unique ID] [Col 1] [ Col 2] [Col 3] [Col 4] [Qty] Table 2 [Unique ID] [Col 1] [Col 2] [Col 3] [Col 4] [Rating]
I’d like to pass the Average [Rating] from Table 2 back to Table 1. The thought was to create a virtual column with [Col 1].[Col 2].[Col 3].[Col 4] in both tables so they reference back and forth, but I’m using a Unique ID in both, so I don’t think I have the typical Parent/Child relationship. Ultimately, I’d like to have a Deck View with: Primary Header:
[Col 1] - [Col 2] Secondary Header:
[Rating] Summary Column: