Creating network chart from database

[Mattie]

Dear reader,

I want to create a Network chart, however I have some a different data structure than usual, here is an example (it is a splitting process, not combining):

ID	Material	output	input
1	cookie		1
1	chocolate	1
1	dough	1
2	pineapple		1
2	peel	1
2	middle	1
3	cookie		1
3	chocolate	1
3	dough	1
3	almonds	1
4	cookie package		1
4	cookie	1
4	packaging	1

I want to see materials as nodes, and the connection between the materials. In example, from 'cookie package' you can go all the way to 'dough'. On the line I would like to see the ID number.

I hope you can help me out achieving this, if you need additional information I am happy to provide that!