I have tried to follow your instructions, but there is no child table available in step 4.
So, I went to the other table and added a column with ColumnType=“LinkToAnotherRecord”. Then I went back to the first table the other table showed up as a child table.
However, it doesn’t auto populate the new column and I have to manually match up the entire table row by row.
Is the LinkToAnotherRecord column referencing the correct data?
Need more clarity on your example, do you mean a lookup in Table B would be “Key1”,“EN” to get the Field1 field in Table A?
LinkToAnotherRecord does not auto-populate because it has no way of knowing which records to link to, however you can populate multiple rows at a time using the API.
How do I specify what the LinkToAnotherRecord column is referencing?
Your example lookup (using “Key1”,“EN”) would be ideal, but I can get by without the language for now.
So, the lookup is not pulling the desired field for the entire table. I can currently click a record in the first table to get a one corresponding record from the second table, but I was wondering how I can generate a complete result table. Not possible without API coding?