Hi team!
I have 3 tables:
1) Invoices
2) Payment + 3) Child Payment --> Here I put the invoices I am paying (can be severals that is why child table)
Child Payment has a column "Invoice" where I want to select the invoices that have not been paid.
The ISSUE: My validation when I save the child item works OK, but when I save the form, it makes a circular error because the Invoice now appears as "paid"
How can I make this validation work?
select(Facturas de Compra[ID Factura Compra],
and([Proveedor]=[_THISROW].[proveedor],[Titular A/X]=[_THISROW].[Titular],
IF([Tipo de Factura]="id5","2","1")=[_THISROW].[Tipo de Pago A / X],
([Pending to pay USD]+[Pending to pay USD]+[Pending to pay USD])>0
))
LinkedIn
Twitter
