We are looking for a component to display a series of records showing their relationships in a flowchart. an optimal solution might allow us to connect the records visually, creating the database joins for the user.
this solution looks close, but open to other solutions.
It looks like there are some good docs/tutorials in the React Flow docs. You can import the JSON in the post above as a starting point and there's some additional documentation on developing custom components that address the Retool side of things.