B
bluemew
Ive got a database containing 2 tables "research activities" and "production
activities" linked via a many-to-many relationship (each research activity
can link to many production activities, and each production activity can have
many research activities
I want to export into MS project to display the objects as elements in a
Gantt-type view. Managed to achieve this for the objects themselves (using
the MS project Export Map) however i'm struggling to figure out how to import
the linkages
In order to import the linkages automatically, I think MS project expects a
text field containing the ID's of the linked research objects (for import
into the "predecessors" field) separated by commas, eg "1,2,6,10".
Any clues on how to set up a query/expression to create this as some sort of
calculated field? not too familiar with SQL or VBA, so the simpler the better
;-)
Alternatively, Anyone got a better method for exporting links into MS Project?
activities" linked via a many-to-many relationship (each research activity
can link to many production activities, and each production activity can have
many research activities
I want to export into MS project to display the objects as elements in a
Gantt-type view. Managed to achieve this for the objects themselves (using
the MS project Export Map) however i'm struggling to figure out how to import
the linkages
In order to import the linkages automatically, I think MS project expects a
text field containing the ID's of the linked research objects (for import
into the "predecessors" field) separated by commas, eg "1,2,6,10".
Any clues on how to set up a query/expression to create this as some sort of
calculated field? not too familiar with SQL or VBA, so the simpler the better
;-)
Alternatively, Anyone got a better method for exporting links into MS Project?