I have designed a system where in there is a group of 6 users of the system. It has a forum, where the users should be allowed to post to the forum and I want to also include the functionality that members of the public can also participate in the forum.
The forum table that I have designed in access has two fields that concern me; a "username" field and a "outsiderPost" field so that when a user adds data to the table, his username is stored in the table and when a member from the public adds their name is stored in the outsiderPost field
I have linked the forum table to the users table so that when i delete a user, the instances of the user posts are also deleted.
But if a member of the public adds to the forum, i get an error from the browser saying that a field is required in the "users" table, which I understand. But then I can do save the record if i open the database and only put in the outsiderPost field and supply the relevant data without the username. How come?
I can leave out the username when i manually open the database, but I cannot do the same thing with ASP coding