Newbie Question (1 Viewer)

[jhoelesmejarda]

Hi everyone I am working with my database design and I stumbled upon this scenario. My database that I am working on is an equipment database which means some of the equipments will have one operator and some will not, now my problem is how can I have the option if the equipment doesn't have any operator say I will add a new equipment but the equipment doesn't need any operator I want it to be just blank. My work around is to create a record in the tblOperator with a NULL as a value but still there is a value in the operator field in the equipment table. Is there any way that I can just leave it blank, in other words, the Operator doesn't need to be required in every equipment that I will add? Thanks in advance

 

[CJ_London]

Providing you haven't set the operator field in the equipment table to 'required', it can be left as null - there is no need to create a 'null' operator