Attaced dummy file
To make this work (not that you couldn't figure it out yourself)...
Open the Order Form and order an item (987 and 126 are still available). Fill in all the other info. For the GID use 1 or 999999 as the value.
To return the item fill in the info.
The query in question is...
Good afternoon!
I have a database that tracks the withdraws and returns of shared tools.
The withdraw form has a check box on it that is checked to show removed when the item is ordered (this keeps that item from showing up in inventory searches). When the item is returned, that check box is...