Cannot define relation (with less than pk attributes)

Classic Servoy
1

Hi

I’m confused since I cannot define a relation the way I want:

I have a relation table defining an m:n relationship between two other tables (lets say customers and products). Each entry in the relation table contains the pk of a customer and the pk of a product. Together they build the pk of the relation table.

I would like to define a servoy relation from this table to the customers table (to get the name). But it seems neccessary for a servoy relation to have ALL primary key attributes involved. Is this true? If yes: I have the strong feeling that this is wrong. And I would appreciate it a lot if you would change it (back?) as soon as possible.

Best regards

2

Solved:

I have to select an other key than the displayed on the left side and ignore all the keys in the list which I don’t use.

Sorry, I should habe remembered.

Regards