Skip to main content

Let's say for example we have two tables, one of Proposals and one of Contacts. The goal is to create a Many to Many relationship between the two tables and have as many contacts associated with a proposal as you wish. K2's wizard is great and will automatically create the SmartObject in the middle to capture the foreign keys. However when this is brought to the form view for whatever reason K2 uses the Get List Items method and uses input mapping to filter by the ID server side which is VERY SLOW!, instead of using Get List Items By ID thus returning the record based on an indexed primary key (VERY FAST). Don't even ask about linking in related data such as a Contact email or phone number as it calls Get List Items AGAIN!!!. On top of all this it appears to call it for each record too thus a proposal with 10 contacts and 6 fields we are looking at 60 x (30 second call) = 30 Minutes! Now either I am doing this completely wrong, and there is a much better bigger picture way to accomplish this but from reviewing the documentation and forums as much as possible, this simply just isnt possible. Why?


12425i321CE7E633401F70.jpg
Be the first to reply!

Reply