multi primary keys relations in 1 table

[Carloj]

Im trying to understand databases but i got a problem.

I got a table with items called "tblArtikel". In this table the supplier and customer of a item is registerd. The suppliers en customers are registerd in the table "Stakeholder". See image:





Now i thought it would be possible to give them both a relation (like the image), but a query does not allow this/cant work this out.

Is there a other way to do this?

[Minty]

Add another copy of the table "Stakeholder" to your query.

[Carloj]

Yes, thanks alot!