When I have multiple records linked to one row of data in a table, is it possible to flatten or split the records?
E.g. If I have Table 1: Record A and I create Table 2: Record B and Record C. If I then create a linked field in Table 1 to Table 2 and link Record B and Record C.
I can see Table 1: Record A, with B and C in the linked field, on the one row.
Is there any way to see 2 rows? E.g Row 1: Table 1: Record A linked to Record B and then Row 2: Table 1: Record A linked to Record C?
This is a major requirement for our usage. I’m not a developer, so any code-less solutions would be great! Thanks.