I am creating a database using Access 2007.


The database has lookup tables that appear as Combo Boxes on the main form.
Some of the combo boxes have an "other" option.
If "Other" is selected in the combo box, then the user is to enter the information in a text or memo box.

Example Combo Box:
Option1
Option2
Option3
Other

I'm not sure how best to set this up so that everything is related properly.

I was thinking that I could create a subform with a field for the combo box and a field for the text/memo box. However, the users won't be entering multiple lines of selection. They will be selecting only one Combo Box item per Form Record. So, I don't think that this is the best approach.

Is it possible to have the Combo Box as a field on the Form and the Text/Memo box as a field on the form?
If so, how would I do this and what kind of relationships do I need to establish?

The database will have approximately 10 of these.

I have attached a basic sample database containing the Lookup Table and the Main Table and Main Form.

I appreciate any assistance/ideas received.