Best practice when dealing with n-n relationships (multi-select)

#1

I’m using Jet Admin with a Xano database and I’m wondering what’s the best way to deal with n-n relationships. I have the following structure:

Companies <-> Company_has_packages <–> Packages.

So I have certain packages which I would like to assign to 1 or more companies. A company can have 1 or more different packages.

What should be the approach?

Ideally I would like to solve it in a form of the package where you have a multiselect field with all the companies and I can just check/uncheck which companies have this package and then save the form. For some reason it’s not that straightforward in Jet Admin. Should I structure my data in Xano differently?

I think it’s a pretty normal use-case, but somehow I cannot get it working. Thanks for every help.

#2

Screenshot 2025-01-09 171746
Screenshot 2025-01-09 171746811×1009 104 KB

Use the JSON field type and a List data structure in Xano to handle complex or nested data efficiently. Ensure that the JetAdmin data source includes a Multiselect field to enable selecting multiple options dynamically.

1 Like