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.
Any help would be much appreciated.