We have the following tables:
One link table (ProductGroup_Product) which supports that one product can be included in many groups. We have exposed these tables using external content types. We want to be able to modify this product in InfoPath and select
one or more groups on each product. The External Content Picker supports multi select. We want to try Scots last suggestion here
i.e. expose a Finder operation on ProductGroup_Product which returns all groups for a specific product. I have spent quite some time trying to get this work in InfoPath without any luck. How to pass in filters on ProductId? How to update the link
table? What about new products that doesn't yet have a ProductId when submitting?
Has anyone stumpled across a good article that describes how to do this? I've seen quite a lot of questions without answers and this seems like a faily straight forward scenario in most systems.
View Complete Post