So the data type of a UserType field is number because it refers to the SecurityID (Autonumber) in the tblSecurityLevel table above. On my database, I setup a table tblWorker that has a UserType field links to a table tlbSecurityLevel. ![]() Create a table tblWorker with a LoginID, Password and UserType fields. Create a table tblSecurityLevel with a SecurityID and SecurityLevel field and add Admin for SecurityID =1 and User for SecurityID =2Ģ. The step of creating Login Form can be followed below:ġ. ![]() ![]() Before creating a Login Form, you need to set up a table that can verify the login ID and password on the Login Form.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |