I want to link the identification number of a lead to another interactions database, but when I try to set it as a connection, it links a different column and doesn’t let me select the ID/column I’m actually looking for.
Does anyone know how to fix this or make it work? I’d really appreciate it 
As far as I know, you can link tables and records but not columns. Knack creates it’s own hidden keys that it uses for that purpose.
The solution I found was to recreate the dataset with only one column, and then select that column in the connection I needed. Knack only recognizes that reference, and it worked.
Thanks, Peter!