Reporting across tables
Hi
New to the forum and pretty new to quickbase. I've used databases before but am struggling a little with what I think should be quite simple! I'd be grateful for any assistance please.
I have a database with 3 tables which is for tracking our first aid kits across a farm.
1. Boxes - a table listing all boxes by number, the type of box and which asset they belong to and location (12, travel, tractor, farm)
2. First Aid Box Records - a table listing the contents of each box by item along with the quantity in each box (tractor, 12, travel, plaster, 6)
3. Stock Records- a table which lists all of the first aid items available with their expiry dates and quantity in main stock (plaster, 30/1/2020, 20)
In my table 2 - first aid box records - I have a report which sums all items showing me a total for plasters, bandages etc across the estate as a grouping by item.
All of these are fine by themselves but I'm trying to get the last table - 3. stock records - to calculate a formula to show how many items we have left in stock once the first aid kits have been topped up - it sounds so simple to me - take the totals from the report in table 2 and minus them from the quantity column for each item in table 3, but I just can't figure it out!
Hope this makes sense and I'd be so grateful for any help (suspect its something really easy and will feel like an idiot but I've given up trying!)
------------------------------
Thank you
Mina
------------------------------
New to the forum and pretty new to quickbase. I've used databases before but am struggling a little with what I think should be quite simple! I'd be grateful for any assistance please.
I have a database with 3 tables which is for tracking our first aid kits across a farm.
1. Boxes - a table listing all boxes by number, the type of box and which asset they belong to and location (12, travel, tractor, farm)
2. First Aid Box Records - a table listing the contents of each box by item along with the quantity in each box (tractor, 12, travel, plaster, 6)
3. Stock Records- a table which lists all of the first aid items available with their expiry dates and quantity in main stock (plaster, 30/1/2020, 20)
In my table 2 - first aid box records - I have a report which sums all items showing me a total for plasters, bandages etc across the estate as a grouping by item.
All of these are fine by themselves but I'm trying to get the last table - 3. stock records - to calculate a formula to show how many items we have left in stock once the first aid kits have been topped up - it sounds so simple to me - take the totals from the report in table 2 and minus them from the quantity column for each item in table 3, but I just can't figure it out!
Hope this makes sense and I'd be so grateful for any help (suspect its something really easy and will feel like an idiot but I've given up trying!)
------------------------------
Thank you
Mina
------------------------------
