Database Design/Combo Boxes and Relationships

  • Thread starter Thread starter Gordzilla
  • Start date Start date
G

Gordzilla

I'm setting up a database and I'm trying to follow the rules for normalizing
it.
I have a master table that has about 7 fields that all store the foreign key
from lookup tables. I had set up a relationship on each field to the lookup
tables as well.
Create the forms with appropirate combo boxes.
Where I run into a problem is that not all of the fields are mandatory so if
the user doesn't enter anyting in the combo box when adding a new record they
get an error stating that a related record is required in that look up table.
Do I need to remove the relationship?
Do I add a null record to the lookup tables?
 
Usually when I get that message it means my "master" table has the
"Required" property set (thus, a record in the master table "requires" a
corresponding lookup table value).

Go back to the table underlying the master form and ensure that those 7
fields are NOT marked "Required".

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top