Let's say I have a SQL table called Product I can update in an InfoPath form.
Let's say the schema of this table is:

ProductName (varchar(50))
ColorID (int)

I can submit changes to this just fine with an Infopath form.  However, I
can't figure out how to get the Repeating Table to show the actual ColorName
instead of the ColorID, because you can't submit to a data source that's got
joined tables.

I've tried Expression Boxes with various filters, but it looks like InfoPath
just won't support the ability to display joined SQL table info if you're
submitting data to the same table.

Any thoughts?