Auto Populate Query

S

Simon Dowse

Hi,

I have an access database as per below:

1 table with usernames (tblUser)
1 table with access level (tblAccessLevel)
1 table with access rights (tblAccessRights)
1 table with access rights and levels granted for each
user (tblUser Detail) - this is populated by me.

then, 1 query which collates the whole lot, and a form
with user details and subform that gives the detail from
tblUserDetail.

I also have a table with descriptions of each access right
and what I want to do is add to the subform so that when
you add a right for a user it also gives the description
from this table. The table (groups) that has the
descriptions has a column for access level and right,
along with the description.

Any ideas how this acn be done?
 
Top