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

[r rad]

Hi,

I'm not sure what your intention is but I'm think that you are want with KEYS type to have m:n relations in Orders (to Members),

and after that to represent only one side relation Members to Orders. 

I think that it is not supported by current Jam.py. Maybe I'm wrong.

When I it try before ..., in version V5 I have to write some JS code and custom table (with custom PKs) for that. 

But I'm don't know enough V7, maybe somebody to know.

PS. And, how to You think, to get more members for one Order in your KEYS field?