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
------------------------------
Thanks for responding Mark.
The context is a "reservation" type system, so I'll want to query a transaction table of reservations (past, present, & future). There may be many transactions for each item.
I'll want to query the item table to find items that are not listed in the transaction table for various reservation days provided for start and end.
I am now opting for a little bit of a messy solution using pipelines, a special table, some interesting relationships, and query formula fields to determine availability for the given time frame.
It's messy and inelegant, but I think it'll work. I'll let this gestate a couple of days and attempt to verify the approach then.
------------------------------
joe vandervest
------------------------------