G
Guest
I am trying to create a data entry form that requires a lot of information
like training codes and job types. All information is saved to a table "Data
Entry". The problem I am having is where I want the user to be able to select
a job type or training code from a combo box instead of trying to remember
what each one is. I have a table listing all job types and a table listing
all training codes. All tables share relationships. When I go to tab through
the created form, entering all required info and selecting items from the
combo box, I get a error saying value for that field (job types or training
code) cannot have a null value. The table "Data Entry" has only training
codes and job types that have been entered. The table "Job Types" lists every
job type and the table 'training codes" lists all training codes. This is why
I need to pull from those tables. Is there a way this can be done?
like training codes and job types. All information is saved to a table "Data
Entry". The problem I am having is where I want the user to be able to select
a job type or training code from a combo box instead of trying to remember
what each one is. I have a table listing all job types and a table listing
all training codes. All tables share relationships. When I go to tab through
the created form, entering all required info and selecting items from the
combo box, I get a error saying value for that field (job types or training
code) cannot have a null value. The table "Data Entry" has only training
codes and job types that have been entered. The table "Job Types" lists every
job type and the table 'training codes" lists all training codes. This is why
I need to pull from those tables. Is there a way this can be done?