I am making an inventory program and im trying to make sure the user can not remove more stock than currantly in stock.
I have a parts Table, and a Nested form inside of another table. The nested form is called “repair parts used”
In the [Amount] Column of the Repair parts used, i am trying to put in a valid if expression like so,
[Amount] - (LOOKUP( [_THISROW].[Part Name], “Parts”, “ID”, “Stock”))> -1
or [_THIS].[Amount] - (LOOKUP( [_THISROW].[Part Name], “Parts”, “ID”, “Stock”))> -1
Taking checking to see if the currant inputted number - the amount currently in stock is bigger than -1.
Its telling me the following error,
Arithmetic expression ‘([Amount]-ANY(SELECT(Parts[Stock],([Id] = [ID].[Part Name]))))’ has inputs of an invalid type ‘Unknown’
Any input would be appreciated,