Skip to main content
Question

Display child records in parent table.

  • October 5, 2023
  • 0 replies
  • 67 views
Forum|alt.badge.img+3

Hi,

I have two tables named Startup and Shareholder. The Startup is the parent to shareholders. There is a field called Shareholders Name in the child table.

 I want to display shareholders' names from the child table to a specific field in the parent table as a dropdown. I tried using the option "Values from this field may be a source for dropdown lists in other apps".

It displays all the shareholder's records. But I want it to display shareholders' records for specific Startups.

Thanks in advance.



------------------------------
Prakash Murali
------------------------------
    This topic has been closed for replies.

    Forum|alt.badge.img+20
    • MikeTamoush
    • Quickbase Alumni
    • October 5, 2023

    Is the list you want specific to the parent? ie, do you want to list all the children in a dropdown? Or is it that you want a list of any shareholders, based off a generic filter?

    If the dropdown needs to be conditional based off the parent, the only way I can think to do this (if you don't just want to show them on a report link), is to make a reverse relationship, and have Shareholders be a parent to Startups. Then use the conditional rules.

    If option two, you could go to your shareholders table and make a formula text field called [Shareholder Names for Multiple Choice List]. In that formula, essentially only show the names of the shareholders you want based off whatever If statements you need. Then reference that field from your Multiple Choice.



    ------------------------------
    Mike Tamoush
    ------------------------------
    Terms & ConditionsAccessibility statement