Hi everyone, I’ve been troubleshooting an issue where multiple virtual fields are not displaying their deref information. I changed the expression from a deref to a Lookup expression and still no data appearing. Its as if the child record (Collection) doesn’t recognize the parent (Route) REF field anymore.
Here’s what I’ve tried.
- Tried LOOKUP expression vs. deref
- Tried ANY() expression
- Saved and verified the table
- Regenerated the Table
- Deselected/Reselected the Routes table from the child table REF field (caused a giant mess had to revert to a backup)
Note: Collection table route_id has no validations etc. - just the REF connection to its parent table Routes