OK, I do think I understand what you mean now but I would have to work with you one on one to get this working. If you have a small budget contact me directly by the email in my signature line and we can discuss this. Probably just take less than an hour of consulting time.
Original Message:
Sent: 09-18-2023 13:07
From: Allan McPhail
Subject: Related Grandchild to parent
Thanks Mark.
How would I get the related material components to show up under the formula.
I don't see any relationship between the formula and the material components.
With there being multiple formula components in a formula is there an easy way to get all of the related materials in the same report?
------------------------------
Allan McPhail
Original Message:
Sent: 09-18-2023 12:24
From: Mark Shnier (Your Quickbase Coach)
Subject: Related Grandchild to parent
I think that this is very easy.
Create a report link field on your formula components table. A report link field will run any report with an extra filter as defined by the report link field itself.
On the left side of the field configuration select Related Material.
On the right side, navigate to your app and then to the set of fields from Material Components and select the field called related material. That panel to locate that field can be a little annoying so I'd like to use CTRL-F control find.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
Original Message:
Sent: 09-18-2023 10:46
From: Allan McPhail
Subject: Related Grandchild to parent
I am building a recipe database and need some help, I'm trying to get the related material components to show on the formula components.
The table structure is below.
The formula shows the formula components as below
------------------------------
Allan McPhail
------------------------------