If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
Database Design/Combo Boxes and Relationships
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? |
#3
|
|||
|
|||
Database Design/Combo Boxes and Relationships
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? |
#4
|
|||
|
|||
Database Design/Combo Boxes and Relationships
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? |
Thread Tools | |
Display Modes | |
|
|