Rowlink to multiple rows

Is it possible to have a Rowlink that links to multiple rows. The use case is Table1 has family information, Table2 has kids. Each family has one or more kids. I would like the people who enter the family information to be able to link to each of the kids for that family.

1 Like

Try adding a family column to your kids table, and have that hold Rowlinks to an assigned family.

In the family table, add a kids column, and then have those hold a formula that filters the kids table by that family.

1 Like

Yup that's what I ended up doing... the concept of a filter in a field is a it's a little unintuitive, but once you know the pattern is certainly works.


This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.