Hello @Belinda,
You are talking about one to many references.
I have asked about this recently as well.
Unfortunately the only way to achieve what you want is to use an interim table that has a reference to the table in which you are trying to make the one to many reference and a reference to the table in which you hold the list column that you wish to reference.
To make things more clear letâs say we have only three tables.
Table A - this is the table in which youâd like to reference several items from a list in another table.
Table B - this is an interim table which has a reference to table A (make sure to mark this reference as Ispartof to make it a child table of table A) and also has a reference to table C.
Table C - this is a table which holds a list column which you will reference in table B.
Because you marked the reference from table B to table A as Ispartof, it will now appear as a child table within table A in which you can make as much references to table C as youâd like.
I would advise you to make a slice table of table A to have control over the way your columns are presented in the form view.