Welcome Guest, Not a member yet? Register   Sign In
DMZ - join table with attributes?
#1

[eluser]Tom Vogt[/eluser]
I'm wondering if this can be done with DMZ or if I have to add yet another table:

I have a user table and an object table that are joined via a join table, due to a many-to-many relationship (a user can have access to many objects, each object can be accessed by many users).

I would like to "qualify" the type of access that a user has. This is not a generic role that spans objects, but is always object-specific. So user A may be admin of object B, but only a regular user on object C.

My intuitive solution was to expand the join table by an access level, i.e.
Code:
object_id
user_id
access_level

But I have not found a way to use this through DMZ. Did I miss something?
#2

[eluser]Tom Vogt[/eluser]
has been answered:

Check out “Working with join fields” in the manual:
http://www.overzealous.com/dmz/pages/joinfields.html




Theme © iAndrew 2016 - Forum software by © MyBB