Is it possible to automatically fill in a checkbox field on the main table from data included on a linked report from another table?
I have linked a report from my Warranty Table to my Jobs Table. The warranty report indicates with a checkmark if the warranty work has been completed. I have a checkbox field in the jobs table that I would like to be checked when the warranty report checkbox is checked.
This is possible. You can use a summary field to count the number of related records that have that checkbox checked and use that field in a formula checkbox. In the formula field you would use a formula similar to the one below
This checkbox would then automatically check when a child record is created and it has the warranty checkbox checked.