My dataset from the smartObject returns some user-facing data and also some IDs of related records in other tables. For example, the following is returned by the Invoice SmartObject:
InvoiceID UserID Invoice Amount Invoice Date
Instead of displaying the UserID, I'd like to display the UserName from the User SmartObject. So, each row would look like:
Invoice ID User Name Invoice Amount Invoice Date
How do I do that? There doesn't seem to be anyplace in the repeating table to insert a rule that can do this.
Maybe I should be doing this off a SmartObject that combines the data BEFORE it gets to the InfoPath form, but I'm not sure how to do that the K2 way. The simple way would be to write a denormalized View that combines this information and then base a SmartObject on the view instead of on the table, but what's the right (K2/SmartObject-style) way of doing it?
-alex