AnsweredAssumed Answered

How would I most likely want to setup a Revision field for Project?

Question asked by brettJames_ on Feb 22, 2012
Latest reply on Feb 28, 2012 by brettJames_

In the application I am building Projects need to be able to have Revisions. So when a user is on a specific Project's detail view I want them to be able to switch to a different Revision of that same Project from a popup menu (ex, Select Revision: 1, 2, 3, 4). The only thing we need to know about a Revision is the "Revision Number and Date." I'm assuming a project_REVISION would have its own unique ID.

 

Is the proper way to go about this by making a completely separate table called Revisions and create a One to Many relationship? Or would something like a Self-Relationship be what I need to do there?

Outcomes