G
glenn
Hello,
I have saved a MS Project file as a MS Access database file.
I need to create a recordset with the following data:
TASK_NAME NUM_VALUE
TASK_NAME is from the MSP_TASKS table and NUM_VALUE is from
the MSP_NUMBER_FIELDS table.
NUM_VALUE represents a custom cost field.
In simple form, I created a MS Project with 2 tasks and a custom cost
associated with each task.
For example,
Tasks Custom Cost
Design Project $10,000
Code Project $50,000
My recordset for the first task would be
TASK_NAME NUM_FIELD
Design Project $10,000
and for the second task the recordset would be
TASK_NAME NUM_FIELD
Code Project $50,000
I am not sure how to link the data given the MS Project Schema design.
Thanks for any help.
I have saved a MS Project file as a MS Access database file.
I need to create a recordset with the following data:
TASK_NAME NUM_VALUE
TASK_NAME is from the MSP_TASKS table and NUM_VALUE is from
the MSP_NUMBER_FIELDS table.
NUM_VALUE represents a custom cost field.
In simple form, I created a MS Project with 2 tasks and a custom cost
associated with each task.
For example,
Tasks Custom Cost
Design Project $10,000
Code Project $50,000
My recordset for the first task would be
TASK_NAME NUM_FIELD
Design Project $10,000
and for the second task the recordset would be
TASK_NAME NUM_FIELD
Code Project $50,000
I am not sure how to link the data given the MS Project Schema design.
Thanks for any help.