SharePoint User Group UK

Does anyone know how I could easily create a many to many relationship between two lists/two document libraries?

Here's the scenario:

We want to use Sharepoint for a purchase order processing vault. Each PO can have many goods received notes and vice versa. We want to store the POs in one library and the GRNs in another with a list of each against the other (so you can see if your order has have any deliveries against it). Is this possible?

Many thanks,

Duncan Gallimore

Hi Duncan , I am going to throw this out to the Dev guys , but Can Infopath be used for this ? seems to be a good option for this type of Business process but I am not highly knowledgeable on Infopath. Infopath to create the data ( ie a PO form ) and then various data view web parts to reference a PO to a GRN for example. Just a thought.

Steve is absolutely right.  InfoPath could be useful for your PO's and your GRN's.  You could then create webpart connections between the two libraries.

Assuming you are not using InfoPath and just straight forward document libraries, you could connect the doc libs using web part connections.  You would need to involve a third list, which is where the dataview webpart comes in.

The dvwp displays the GRN & PO# column from one of the libraries, but provides connections to both of your document libraries.  Therefore, if you click a line which states PO1, and GRN1, both libraries will be filtered.

 

Hope this makes sense.

 

Brett

---

Brett Lonsdale
Partner/Trainer
Combined Knowledge
MCT, MCSD.NET

Thanks for getting back to me so soon.

Just to clarify, I create a list with columns called PO and GRN which could have rows like this:

PO   GRN

1      1

1      2

2      3

Then I create a dvwp connecting the three? Are the fields hyperlinks to open the documents?

Sorry - I'm new to all this, trying to learn fast.

Duncan

Duncan,

 

No probs, yes, create the columns like you said. and then connect them, and have a hyperlink column to fire the connection.

send me your email to brett@combined-knowledge.com.  I will then send you a screen dump as I tested it before replying to you.

 

Brett

---

Brett Lonsdale
Partner/Trainer
Combined Knowledge
MCT, MCSD.NET