Hi @ildeloge ,
Do you want to display all related items of 6 tables based on 1 tables?
If so, I suggest you use a gallery to display table1, insert 6 listboxes(or galleries) inside the gallery to display other tables.
Could you tell me whether these lookup fields allow multiple choice? I assume that no.
I've made a similar test for your reference:
1)set gallery1's Items:
table1
2)insert 6 list boxes inside the gallery:
3)set listbox1's Items:
Filter(table2,table1ID.Value=ThisItem.ID)
set listbox2's Items:
Filter(table3,table2ID.Value in
Filter(table2,table1ID.Value=ThisItem.ID).ID
)
set listbox3's Items:
Filter(table4,table3ID.Value in
Filter(table3,table2ID.Value in
Filter(table2,table1ID.Value=ThisItem.ID).ID
).ID
)
set listbox4's Items:
Filter(table5,table4ID.Value in
Filter(table4,table3ID.Value in
Filter(table3,table2ID.Value in
Filter(table2,table1ID.Value=ThisItem.ID).ID
).ID
).ID
)
set listbox5's Items:
Filter(table6,table5ID.Value in
Filter(table5,table4ID.Value in
Filter(table4,table3ID.Value in
Filter(table3,table2ID.Value in
Filter(table2,table1ID.Value=ThisItem.ID).ID
).ID
).ID
).ID
)
set listbox6's Items:
Filter(table7,table6ID.Value in
Filter(table6,table5ID.Value in
Filter(table5,table4ID.Value in
Filter(table4,table3ID.Value in
Filter(table3,table2ID.Value in
Filter(table2,table1ID.Value=ThisItem.ID).ID
).ID
).ID
).ID
).ID
)
Then, listbox1 will only display related items in table2.
Listbox2 will only display related items in table3.
Listbox3 will only display related items in table4.
Listbox4 will only display related items in table5.
Listbox5 will only display related items in table6.
Listbox6 will only display related items in table7.
Best regards,
