I'm trying to import data as a new collection with a reference field, however every time I do this, the imported reference field has "Reference Broken" error. I can't understand why.
Here's what I'm trying to do:
Import a list of schools and school holiday dates. Holiday dates are set by region. If a school belongs to that region those holiday dates should be returned in a table.
Table 1: List of schools - 1000 records, each individual school has a region field
Table 2: List of dates by region, 150 regions. The region in this table is the primary key.
Region field in the school and the region table are an exact match
I want the region fields to be linked as a reference field but every time I try to upload these the reference field seems to fail.
What am I doing wrong?