So I have three lists in a Sharepoint. User list, Customer tracker and Engagement list. I have made a look up column in engagements that looks up to or from customer tracker list, name column to be specific. Both columns are called Column name. I have automated forms to collect data and feed it the respective list. Now the name column that looks up to the tracker name column is returning a blank when data is entered. at first i made it look up to ID column, and it was still the same? any solutions around this?
