Term relation and Primary-Foreign key in Define Relation

Classic Servoy
1

Hello All

I am wondering for some time now about two naming things in Servoy, may be someone can enlighten me a little bit:

  • Why is a relation not called relationship? The term relation is used for a subquantity of a cartesian product? So a relation for me is something different than a relationship.

  • The Define Relation window says on the the left column Primary key, and on the right column Foreign key. But when I define a relationship from the m-side table to the 1-side table, the Foreign key is in the left column (labelled Primary key) and the primary key is in the right column (labelled Foreign key), to me this is quite confusing. For an example to see what I mean look at the solution crm, relationship contacts_to_companies from table contacts to table companies.

Best regards, Robert

2

Robert,

I also found it confusing, particularly as I am new to Servoy and database programming in general.

The answer I was given to a similar question is in the following thread.

MerMer