enter image description here

Can you please tell me how to make such a connection?

As a result, I want to get a drawn connection. It’s just not possible to make a connection because Swears on data integrity. Specifically, I need to put a dependency between instances of the "id_network", for this I brought them into a separate table, but I cannot put a dependency on the composite key of the second table from one key attribute.

  • Try to write more detailed questions. Explain exactly what you see the problem, how to reproduce it, what you want to get as a result, etc. - Nicolas Chabanovsky ♦
  • Very strange, in my opinion, the table "Supplier_ Buyer". It simultaneously contains both information about the entities and the relationship of these entities. Do you want to tie these pairs to the networks? I would seriously think about the architecture and the normal form of such a database. But if you want to link all the same, then in this table you need to add the field "net_ref_ref" as a link (secondary key) to "Id_seti" - Nikola Tesla

1 answer 1

Thanks for the help, but the solution to the problem turned out to be much simpler!) It is necessary to take out the linked table in the field two times (and ACCESS calls it marked "_1") and link each of them with different attributes. The example in the picture ... enter image description here