T
tommu
Hi, I am creating work to lists from a list of standard activities.
Each activity has a time column that may be changed but the other columns in
the row are standard.
I have created a table with the standard activity data eg.
ActivityID(Primary key), ActivityNo, Description, StdHrs. I do not need all
of these activities for every job and need to select only those that I need
and add them to my list of activities in my job table.
When I create a new job, I click on the list box to select an ActivityNo and
want all three fields (ActivityNo, Decription, and StdHrs) to be appended to
my job table.
The job table has the fields JobID(Primary key), JobNo, ActivityNo,
Description, PlannedHrs. I then change the planned hours if necessary go on
to select the next ActivityNo that I want to include in the job.
Thanks
Each activity has a time column that may be changed but the other columns in
the row are standard.
I have created a table with the standard activity data eg.
ActivityID(Primary key), ActivityNo, Description, StdHrs. I do not need all
of these activities for every job and need to select only those that I need
and add them to my list of activities in my job table.
When I create a new job, I click on the list box to select an ActivityNo and
want all three fields (ActivityNo, Decription, and StdHrs) to be appended to
my job table.
The job table has the fields JobID(Primary key), JobNo, ActivityNo,
Description, PlannedHrs. I then change the planned hours if necessary go on
to select the next ActivityNo that I want to include in the job.
Thanks