InfoPath Dev

I'm used to combo boxes in Access and Excel where you can bind a particular column as the results but look at a different column to make your choice (like you see the client name, but you are actually selecting the client ID when you make your choice).  It would appear that this is not possible in InfoPath.  What I want to do is have the user select the client they want, but I also need 2 other pieces of information - both are ID numbers.  How would I accomplish that?  (Ultimately, I want to see ID1, ID2, Client Name.)

Thanks!

This is entirely possible in InfoPath.  In the ComboBox's properties, you can specify which field is the Display field, and which is the Value field.  This means that when an item is selected, the bound field will take on the corresponding "Value" value.  Once you have that, you can use some rules and filtered XPath to retrieve any related values you need.