I have Doc with several tables of Student information. Each student is identified with a unique “Student Number”. The table “Student Master” has all the key information about a student. In another table, I would like to pull in some of the Student Master data, including a field called “SPED” which is a checkbox that indicates whether or not a student receives special education services. I have added a formula as follows:
Filter([Student Master],[Student Number]=thisRow.[Student Number]).SPED
The formula returns “true” or “false” depending on the Checkbox status of the referenced field, but when I try to display the field as an actual Checkbox, I get an error message stating “Cannot convert value to the specified format.” How can I get this to display as a Checkbox properly?