Database Design/Combo Boxes and Relationships

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


"Gordzilla" wrote in message
...
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?

Go to your Master table in design view One at a time selec each foreign key
field then go to the bottom and delete the 0 for the default value.

Steve



"Gordzilla" wrote in message
...
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?

Removing alll the 0 from the default value did the trick.

thx


"Mark" wrote:

Go to your Master table in design view One at a time selec each foreign key
field then go to the bottom and delete the 0 for the default value.

Steve



"Gordzilla" wrote in message
...
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?