Hi, I wonder if you can help me. I’m stuck with a linking problem between tables in bases.
Scenario: We have several clients and some of them have completed a feedback survey(s). I wish to create a column that counts the total number of feedback surveys completed by each client. Clients are stored in BASE1 and completed surveys are stored in BASE2. I have activated ‘Sync data to another base’ to make the survey table data available in BASE1 and that is all working fine.
I then created a ‘Link to’ column in the Clients table and pointed it at the synced Survey table (both in BASE1). I was expecting this ‘Link to’ column to be automatically populated with a unique reference to the survey number(s) or be blank if no survey existed. Instead, the ‘Link to’ column is entirely blank and when I click into it, I get a pop-up to create a relationship between individual data points in the Clients and Surveys tables. I don’t want to create individual relationships because that already exists via the Client name which is both tables.
Any ideas on how I get the ‘Link to’ column to auto-populate?
Thanks, in advance, for your help.
Kind regards
Ben
