DBApprentice
On Error GoTo AWF *****:
- Local time
- Today, 00:43
- Joined
- Dec 24, 2018
- Messages
- 150
Hello again!
I have a pretty simple question (For you, of course, too complex for me):
Considering you have to record information (Like a complaint) coming from people that wants to be anonymous what would be the best approach when comes to database design?
First I considered creating a "person" named UNKNOWN. But later I tought I could accepct NULL values on the person´s name, but now I am on the middle of building the forms to see the complaints and the blank textbox are looking very odd... So I decided to add a checkbox named "UNKNOWN" and trhow some code for enabling/disabling controls, err... too much trouble for a simple task.
Now I am thinking maybe I could add a checkbox to the original table if a person remains anonymous I will fill it.
What would you guys do? If a table will address anonymous people should I remain with Nulls or move to "UNKNOW" solution. If I am not even right about these approaches please be my guest to propose your solution.
PS: Please consider this is my very first project in Access and I am still settling DB Design in my mind.
I have a pretty simple question (For you, of course, too complex for me):
Considering you have to record information (Like a complaint) coming from people that wants to be anonymous what would be the best approach when comes to database design?
First I considered creating a "person" named UNKNOWN. But later I tought I could accepct NULL values on the person´s name, but now I am on the middle of building the forms to see the complaints and the blank textbox are looking very odd... So I decided to add a checkbox named "UNKNOWN" and trhow some code for enabling/disabling controls, err... too much trouble for a simple task.
Now I am thinking maybe I could add a checkbox to the original table if a person remains anonymous I will fill it.
What would you guys do? If a table will address anonymous people should I remain with Nulls or move to "UNKNOW" solution. If I am not even right about these approaches please be my guest to propose your solution.
PS: Please consider this is my very first project in Access and I am still settling DB Design in my mind.
Last edited: