How can we link Detail to Master by field with type KEYS

[Zoi Moravec]

Hi all!
A have table Orders and field members_ids with type KEYS

In any order (order_id = 1) there are can be many members. i.e. field members_ids = 1;2;3 (for example)

And i have table Members and 2 some classic Details tables for it.

How can i add Orders table as detail table №3 for Memebers and show the same record with (order_id = 1) for diffrent members with id=1, id=2 and id=3? This like "many to one" linking...

[Dean D. Babic]

Maybe something like:
https://billsofmaterials.pythonanywhere.com/

https://billsofmaterials.pythonanywhere.com/static/internal/bom_1.0.0_7.0.52_2026-05-20_02-49-15.zip

But not sure...

[Zoi Moravec]

Yes, it's nice case, but it would be great include table bom_assembly_subparts not in view-subdetail, but in view-detail in separate Tab (tabs-div).

среда, 20 мая 2026 г. в 05:51:53 UTC+3, Dean D. Babic:

[Dean D. Babic]

It is:

set_where({members__contains: item.id.display_text});

not the:

set_where({members__contains: item.id.value});

Took me a while to figure this out since value produces a tracback! Might be a bug

I do not know how would you display this is a 3rd Detail tab tho. Try to search, ie: https://groups.google.com/g/jam-py/c/uNZrOBVPXeE/m/D0pftkLXAQAJ

[Dean D. Babic]

Sure thx.

If you figure how pls do tell :) I spent heaps time on this since it was an idea from Django. And still not great coz of Summaries.

Here is the schema:
https://billsofmaterials.pythonanywhere.com/static/bom.html