Hi
I might be missing the pot totally but I can't seem to get it right. I want to build a single listview of data that has different SmartBox SMO. So I have Orders SMO and a BusinessCard SMO. In SQL I will build a SP with a simple join and get the correct details for the Businesscards. How do I go about that in K2 SmartBox setup?
I tried doing Associations by doing joining the Order table to Businesscard or visa versa but I dont see the fields I need.
SELECT BusinessCards.NameSurname, BusinessCards.AreYou, BusinessCards.Title, BusinessCards.Qualifications, BusinessCards.MobileNumber, BusinessCards.DirectNumber, BusinessCards.SwitchBoardNumber,
BusinessCards.FaxNumber, BusinessCards.EmailAddress, BusinessCards.AssistantNameSurname, BusinessCards.AssistantDirectNumber, BusinessCards.AssistantFaxNumber,
BusinessCards.AssistantEmailAdress, BusinessCards.Originator, BusinessCards.ConceptAttachment, BusinessCards.TitleOther, BusinessCards.OrderID, Orders.OfficeName, Orders.Address1, Orders.Address2,
Orders.Address3, Orders.Address4, Orders.SpecialInstructions, Orders.OrderDate
FROM BusinessCards INNER JOIN
Orders ON BusinessCards.OrderID = Orders.ID
Charl