I've been trying to figure this out for some time, any help would be greatly appreciated!
Scenario - A company rents tables for parties. They have 3 tables in inventory (4ft, 6ft and 8ft).
A customer wants to rent the 6ft table on Saturday. Jeff creates the rental and reserves the table.
Another customer calls and Nancy answers the phone. The customer wants to rent the 6ft table on Saturday. Nancy creates a new rental and does an inventory search. She should only see the 4ft and 8ft avalible.
I have a system in place now, however it does not prevent other users from double booking equipment.