Let's take the Person-Address Relationship as an example:
- Many-to-Many: Each person can have several addresses; each address can belong to several persons
Now what I want to do is: Have two ListGrids; one listing the persons and their addresses; another listing the addresses and the persons that belong to an address.
I have one DataSource for person, another for address; but there's no array/list type I could use for a foreign key field in the DataSources; that is a foreign key field can only point to ONE related record, not to many. Is that correct ? So what would be the correct approach to model Many-to-Many Relationships with DataSources ?
- Many-to-Many: Each person can have several addresses; each address can belong to several persons
Now what I want to do is: Have two ListGrids; one listing the persons and their addresses; another listing the addresses and the persons that belong to an address.
I have one DataSource for person, another for address; but there's no array/list type I could use for a foreign key field in the DataSources; that is a foreign key field can only point to ONE related record, not to many. Is that correct ? So what would be the correct approach to model Many-to-Many Relationships with DataSources ?