I hope all of you are well. Please go over my request and try to answer.
My requirements are as follows
i) have to create a record maintenance system ii) each record would have some entries, including an important field called PARENT iii) the parent field would store the ID of the parent document. The parent document refers to any related document at the start of the chain.
for example, there is an internal requisition request to purchase hardware. That is one document. Against that document, there would be purchase order, invoice and other documents. So, when creating entry for invoice there should be a way to ref to the parent document (which is internal requisition request).
iv) The user should be able to add this record v) The user should be able to upload multiple files vi) The user should be able to search the record and display results along with attachments in a gridview vii) The search fields are date, description, and title viii) The user should also be able to edit the record (edit fields as well as add/remove attachments)
Question: 1) I have completed the above requirements except the relational part of parent-child documents. How to achieve that?
Also, following is my solution so far. I need to know IF THIS IS THE CORRECT SHAREPOINT WAY TO DO THINGS, OR IS THERE A BETTER SHARPOINT WAY
2) Created a visual web part for search and display records and attachments in a gridview. That is pretty much straight coding against the server object model so no issues there. But, is there a better approach? Better in terms of more sharepointy way to achieve things?
Please let me know alternate solutions and techniques as I am still learning Sharepoint and want to achieve everything within the confines of Sharepoint (to facilitate my learning).