Cross-Doc Column Not Bringing the Right Values

Hi all Coda Makers.

I have 3 tables: Class, Students and Attendance. The Class table has a column of Students in each Class, and another column of only “Active” students.
Then in Attendance Table, we have a select list column that refers to Class column to get list of “Active” students of that particular Class, for us to select the students attended on a particular date.

This all working correctly in the original doc. But in cross-docs, the select list column doesn’t populate the correct students, and I can’t even understand how it gets the student list.
I have all the relevant tables also imported via cross-doc into the new doc.

So I am now stuck, as the original doc is working as intended, but none of the destination docs with cross-docs are working. If anybody has an idea how to solve this, kindly share. TIA

1 Like