Display related datasets based on a repeating field?

[Wintermute101]

This is probably one of the easiest thing one can achieve with a.) relationships and b.) repetitions - but as I have never done much with both features, I just can't seem to figure it out.

Table A (Persons) in my DB has fields

- Person Name

- Person ID (not a repeating field - each person has just one ID and name).

Table B ("Groups") in my DB has fields

- Group Name

- Group Member ID (repeating field - each group has several members)

The relationship between the tables is of course A:"Person ID" to B:"Group Member ID".

Now in a layout, I want to display and edit Groups (Table B), by:

1.) entering B:Group Member IDs (several values in the repeating field) and

2.) seeing related records from Table A.

Now I can have the repeating B:"Group Member ID" field and display A:"Person Name" right beside it - but as this is not a repeating field in A, it only works for the first member of the group.

So - how can I display related datasets from another table based on a repeating field? In this case: Enter 5 Group Member IDs and see the names of the five persons with those IDs from the other table displayed beside it?

As I said: This is probably trivial, but I can't figure it out.

Thanks a lot!

[comment]

how can I display related datasets from another table based on a repeating field?

You could use a portal to Persons to show the related records. Or define your value list to also show the person's name?

BTW, I don't see the advantage of using a repeating field here; it seems to me a checkbox field would be more convenient. This is of course assuming you can get away without using a proper join table to resolve the many-to-many relationship between People and Groups.