C
chett via AccessMonster.com
Hi!
I have been trying to build an automated schedule using tables and forms.
This is how they are laid out.
Table 1 (updatable)
Table 2 (Cannot be updated)
Job Event:
Job Type:
Job Event Id (Primary Key)
JobEvent ID (Primary Key)
JobType ID (Foreign Key)
JobName
Job Name
Job Parameter Number1
Job Parameter Notes1
Job Parameter Default Number
Job Parameter Value1
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
I have been trying to build an automated schedule using tables and forms.
This is how they are laid out.
Table 1 (updatable)
Table 2 (Cannot be updated)
Job Event:
Job Type:
Job Event Id (Primary Key)
JobEvent ID (Primary Key)
JobType ID (Foreign Key)
JobName
Job Name
Job Parameter Number1
Job Parameter Notes1
Job Parameter Default Number
Job Parameter Value1
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