So you have a Suppliers table, with a Linked Record field to connect with Invoices table, isn’t it? And you have several Invoices linked to every Supplier. So, you could have:
- All Invoices paid
- Some Invoices paid, and others not paid
- None Invoices paid
So you can’t do this:
You could have a Field indicating if there is a pending Invoice, for instance.
You cannot do this neither, because the Linking field is like an auxiliary field, like a ghost You have to work with Invoices in the Invoices table. You could Filter them (and even Group by Supplier) in a new View, to see only pending ones.
Also, in the same way, you could create a new View in Suppliers table, seeing only those with pending Invoices (but in the Invoices linked record field you will see ALL the invoices related to that Supplier).