General question about settings up relationships

[smguenther]

Hello,

I have a general question about setting up realtionships:

How does Sugar decide which field(s) to use for setting up a relationship between two modules?

When I have a look at relationships between two tables of a database, I have to choose two fields which contain the same data. Does Sugar automatically recognize the right fields?

Is there a chance to somehow manipulate the choice of fields?

Thanks for any help/hints,

Stefan

[agcopley]

Hello,

I have a general question about setting up realtionships:

How does Sugar decide which field(s) to use for setting up a relationship between two modules?

When I have a look at relationships between two tables of a database, I have to choose two fields which contain the same data. Does Sugar automatically recognize the right fields?

Is there a chance to somehow manipulate the choice of fields?

Thanks for any help/hints,

Stefan

Sugar links the 'id' fields of the respective modules to an intersection table created for the new relationship.
Check the metadata folder for examples of how relationships are defined.

Rgds
Andrew