AnsweredAssumed Answered

Nested ID records

Question asked by jplfrogs on Jul 20, 2016
Latest reply on Jul 21, 2016 by jplfrogs

HI All,

I'm in the process of developing a database to manage project information for a conservation organizations (any developers doing probono work it would be great to talk with you..). I need to capture information on project objectives and activities. I have project table that is related to an objectives table which in turn is related to an activities tables. One project will have multiple objectives and one objective will have multiple activities. I need to automatically a generate objective and activity numbers. Activities number will be based off the objectives and objectives will start from 1 on each project. The table below might explain this better.

project
objectivesactivities
a
1
1.1
1.2
2
2.1
2.1
b
1
1.1
1.2
1.3

Any help would be much appreciated.

Outcomes