Validate Group Code During Registration
We are allowing users to register online. We want them to enter their special group number so we can limit their access to only data within that group. We do not want to do a dropdown list becuase we do not what to expose the group codes. We have a user table and a group table. The group table has the codes for the groups. The user has the user information, including a field for the group that they beloing to. How do we validate that the group number they entered in the registration form is an active code in teh groups table?