I have built a BDC with VS2010 and Sharepoint Enterprise as target platform. It is basically a technical evaluation about many-to-many Associations in external content types.
Its has 2 entities which are Person and Ticket and should reflect a data model where persons can work on multiple tickets and tickets can also involve multiple persons. For linking those 2 entities I have a link table which can be read via the "Navigators"
and be modified via the "Associator/Disassociator". I made the model completely with the VS2010 bdcm designer and as far as I know its good. (Its a "foreign key less" association, the identifiers are UInt32.)
Now my question is how do I actually use those manipulators, or at least show data and related data. With 1-to-n relations Sharepoint did render an interface for handling the relation for me, but with a keyless n-to-m relation I dont get any interface for
connecting the entities at all.
Then I tried to make this via Infopath, but as far as I can tell, you cant use a 2nd datasource there with external List. (And it seems to be supposed to be this way.)
View Complete Post