I'm building a small app to manage catering equipment (think plates, glasses, cutlery, but also larger appliances for live cooking, like barbecues and ovens).
Basis is an inventory list containing items and item count (e.g. 100 champagne glasses, 150 cocktail glasses, 2 barbecues, etc.)
The idea is to "book" X amount of available items (e.g. 40 of 100 available champagne glasses) for a certain time period. For this time period, there are now only 60 champagne glasses left available.
Subsequent bookings can now only use those 60 glasses (if the timeframe for the new booking overlaps with the previously reserved timeframe).
- Items (listing inventory)
- Bookings (details of the single bookings including start/end date)
- Item_bookings (listing the items and # of items for every booking)
The basic mechanics are working. Now, if I open details for an item in the Inventory table, I want to list the bookings (including start and end date) this item is used in, and in what quantity.
VC with [Related Item_bookings][ID_booking] gives me a nested table with related bookings, BUT I also want to display how many of this item have been allocated to those bookings.
I'm thinking I would need to add a VC to the bookings table that is calculated based on values from the current (Inventory) row I'm looking at? Is that even possible?
LinkedIn
Twitter
