I have an App used by a construction co. Basically what this bit does it allow the app user to add the items they have fitted. Each different item is added as its own record. This formula in [Number Remaining] stops the user from saying they’ve fitted 6 items, from a inital total of 10, if they have already fitted say 6. In this case if they’d fitted 6 and put in another 6 then [Number Remaining] would be -2 and trigger a seperate Valid_If formula
The issue I have is somehow the user has added a heating cyclinder twice. When there is only 1 in total. I cannot see how this has happened, nor replicate it.
My hunch is its somehow to do with the Select() reading the table, but not the current record. Or how this all works if the internet is not behaving. This is the abrevated formula:
Get the total number of this item for this house type
deduct off any records already saved to the table
add the number of items in this record
Any ideas or suggestions?