Skip to main content
Question

Related Grandchild to parent

  • September 18, 2023
  • 0 replies
  • 45 views
Forum|alt.badge.img+1
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 CAS Numbers are a list of items.
Materials are added before the formula is raised and have multiple material components.
When the formula is populated with formula components I want the related material components to show in a report on the same form.
The formula shows the formula components as below
I would like to do this with relationships if possible due to them being more reliable.


------------------------------
Allan McPhail
------------------------------
    This topic has been closed for replies.

    MarkShnierYou
    Forum|alt.badge.img+24

    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
    ------------------------------
    Mark Shnier. Your Quickbase Coach
    Terms & ConditionsAccessibility statement