C
chett via AccessMonster.com
I have been trying to build an automated schedule using tables and
forms.This is how they are laid out. Please help me to determine if this is
an efficient way of doing it. Any suggestions are greatly appreciated.
Table 1 (updatable)
Job Event:
Job Event Id (Primary Key)
JobType ID (Foreign Key)
JobName
Job Parameter Notes1
Job Parameter Value1
Table 2 (Cannot be updated)
Job Type:
JobEvent ID (Primary Key)
Job Name
Job Parameter Number1
Job Parameter Default Number
Job Parameter Description1
Job Number (Integer) (not sure if I need this field to save a job more than
once)
Form
Weekly Processing Schedule:
I have a combobox "Job Type ID" calling the Job which fills in the other
fields on the form. The problem is I would like to use a particular job from
the combobox(listed only once) more than once and change the parameter value
and save the record with a different Number. Please help as this is very
important.
Thanks in advance
Chett
forms.This is how they are laid out. Please help me to determine if this is
an efficient way of doing it. Any suggestions are greatly appreciated.
Table 1 (updatable)
Job Event:
Job Event Id (Primary Key)
JobType ID (Foreign Key)
JobName
Job Parameter Notes1
Job Parameter Value1
Table 2 (Cannot be updated)
Job Type:
JobEvent ID (Primary Key)
Job Name
Job Parameter Number1
Job Parameter Default Number
Job Parameter Description1
Job Number (Integer) (not sure if I need this field to save a job more than
once)
Form
Weekly Processing Schedule:
I have a combobox "Job Type ID" calling the Job which fills in the other
fields on the form. The problem is I would like to use a particular job from
the combobox(listed only once) more than once and change the parameter value
and save the record with a different Number. Please help as this is very
important.
Thanks in advance
Chett