Hi, regarding reference fields in the database, the reason for these is because we can't connect more than one dataset to a table/list/grid so we use reference fields from other databases to connect the data.
I have a table that pulls in data from a dataset for game data which includes player name, date pitched and number of pitches. All looks great. However, it is supposed to pull the division data for these players from the ref field in the team data collection however it is not showing the data.
I have checked permissions and all look ok. I checked the live database and the the division for these players is populated in the team data collection.
Can anyone help me fix this? I am obviously missing a step someplace!