"Other" for combobox category Problems

[Sandy]

Hello -

Management wants a category of "other" in the list for the combobox and a
textbox where users can enter "other."

Yikes -- I can see, for instance, if users were to type "cake", they may
type it as "caik", "kake", "Kaik", etc. I don't want to just insert this
into the tblDessertType and have it automatically be available for other
users. I was thinking perhaps I should insert it into a temp table for
management review first.

There has to be a textbook solution for this problem, but I have not come
across it.

Any suggestions on the best way to handle a situation such as this would be
appreciated!

 

[Allen Browne]

Add "Other" as an item in tblDesertType, so the user can chose it.

Then in the table where customer chooses their desert, include 2 fields:
DesertTypeID Foreign key to tblDesertType.DesertTypeID
DesertDescrip Text (255)

When the user chooses Other, they must then fill in the DesertDescrip for
this particular occasion.