I have a form that I use to enter information, and now and then it changes just a tad (this is my personal music collection, and occasionally I'll diversify and add a new musical genre).
I have a GENRE field in my ALBUMS table that includes a lookup (combo box). (I also am using a combo box in my form).
Actually I have 2 questions:
Since I will enter records directly into the table on occasion, I put the combo box at the table level permissions along with in essence duplicating those permissions in my validation rules. Is it necessary to have that much detail/redundancy (validation rule AND the combo box)? I think ensuring my data entry is correct is important but might be going a little overboard...
I also have a combo box on my form. When entering data into a control on my form, does it utilize the business rules (on my table) if none are entered on the form? I placed the combo box w/ the same lookup and was just thinking maybe I could do it a little easier?
What I am actually wanting to do and why I need this info
I want to add the capability of entering a new genre into my table; I'd like the db to recognize it is not in the db and prompt me if I want to add it. Example: if I want to add the genre ACCESS DB, I want the form to recognize that that is not in my table (OR FORM) lookups/combo box and ask me via a message box if I want to add it.
I think I've seen this functionality somewhere in a tutorial, but darned if I can find it!
I have a GENRE field in my ALBUMS table that includes a lookup (combo box). (I also am using a combo box in my form).
Actually I have 2 questions:
Since I will enter records directly into the table on occasion, I put the combo box at the table level permissions along with in essence duplicating those permissions in my validation rules. Is it necessary to have that much detail/redundancy (validation rule AND the combo box)? I think ensuring my data entry is correct is important but might be going a little overboard...

I also have a combo box on my form. When entering data into a control on my form, does it utilize the business rules (on my table) if none are entered on the form? I placed the combo box w/ the same lookup and was just thinking maybe I could do it a little easier?
What I am actually wanting to do and why I need this info

I want to add the capability of entering a new genre into my table; I'd like the db to recognize it is not in the db and prompt me if I want to add it. Example: if I want to add the genre ACCESS DB, I want the form to recognize that that is not in my table (OR FORM) lookups/combo box and ask me via a message box if I want to add it.
I think I've seen this functionality somewhere in a tutorial, but darned if I can find it!