Sub-Select in Query ?
I'm trying to generate a list of items in one table that don't exist in another table based on query parameters. Intent is to create a system whereby a clerk can check on availability of an item bet...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendI am trying to understand what you're asking for here.
You are saying you have a list of items. And you want to know which of those items is not in another table. So can't you just have a Formula Query Checkbox on each individual record to check if that particular item is in The other table or not.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Resolved
Ugly as it is, I was able to solve this problem. The challenge was to create a rental screen that could be used to select a type of rental based on start/end dates, and use these to generate a list of items that were available for the desired time period.
Here's roughly how i did this - (note this solution may not scale really well, but at my low transaction and data level it works fine):
--- User provides type of equipment and start/end dates for borrowing the device type using a request screen.
--- When saved as an inquiry this triggers a pipeline to copy the list of inventory items for that item type.
---- The generated list of inventory items contains query formulas that examine all existing transactions and reservations to decide if this item for this request, based on the request dates, would be available.
---- using a selector that provides ONLY a list of items available for the requested date period, pick the individual item to be rented/loaned
------------------------------
joe vandervest
------------------------------