How to create a unique revision to a record by linking it back to a record within the same form....

How to create a unique revision to a record by linking it back to a record within the same form....

Lets say I am cooking and I have 10 recipes. So, I create a form with each recipe as a record and I give that recipe record a name. ie. Carrot Cake. Now I want to experiment with the ingredients in that recipe, so each new experiment would be a revision of that original Carrot Cake recipe.

So I create a field Revision. Can I create a lookup field that would show what revisions had been previously created for the Carrot Cake recipe? So that duplicates are not created? Or can a formula of some kind automatically increment?


So the record would have fields:
NAME      Carrot Cake
Revision  Rev 16            (want to ensure that a revision 16 had not been created last month)


Not sure I'm really even asking this in the right way.
Thanks in advance from a novice user....