I have a Sharepoint List Form. Any user can come in and fill out the form. I need the user to be able to see his/her own document. The user submits the form to the his/her manager for approval. Once the manager approves or rejects, if Approved goes to his manager for further approval and so on till it reaches the top Manager and the Top manager and all below managers should see their documents only that they have approved it.
How can this be done? I don't want to create groups as it would be too many groups for access control. The user will select his/her Manager from Active Directory and the Manager will select his / her Manager from Active Directory too and so on.
Please advise, how can we go about doing this and if this is possible in Sharepoint 2007 standard version out of box functionality with minor modifications.