How to make a connection from several fields to one field?

Question

Microsoft Access

There is a database "Video rental".
In one table "Cassettes" there is a key fieldCassetteCode , in another table "Customer" there are three fieldsCassetteCode1 , CassetteCode2 andCassetteCode3 .
When I try to make a connection from three fields to one field, I get errors in creating data integrity.
Link creation
Error
Properties of all three fields

Answer 1

If I understood correctly, this is necessary for, for example, obtaining information of the client type - the name of the Cassette1, the name of the Cassette2, etc.
Make three connections in reverse.
those. table Client -> table Cassettes.
Cassette Code1 -> Cassette Code Cassette
Code2 -> Cassette Code Cassette
Code3 -> Cassette Code