I am experimenting with a test database prior to purchase. I have set up user security and have three security levels Admin (1), User (2) and Moderator (3)
The sec_users file has these fields:
login
pswd
name
email
active
activation code
All of those fields are available in the new user entry form ( though some are hidden )
My problem is that no joining record is being added to sec_users_groups, setting the group_id field to “2”
Can someone help me understand how to join the sec_users_groups table to the sec_users table in the entry form? If I can get the tables joined, I think I know how to set the default value for the field.
Thanks