InfoPath Dev

Hooray! glad to have been of assistance. :)

Hooray! glad you got it. This is one of those things that can be really tough when you first start but once you have it figured out one time, gets easier the next. :)

I made a simplified example of what I'm trying to accomplish - see the below screenshot.  This is a secondary data source (similar to how my real one is setup) in a repeating section, Main Color is a dropdown field that the user can change. So, if a user changes the Main Color for the Horse - Main entry (C2), then I need the ...

 Hi, Thank you so much I managed to get this working :) you are a credit to this forum...  

 I found it. I was using the wrong table. Instead of the table with the lookup column (stock) I needed to use the primary table (locations).

Well, Infopath didn't found it out on it's own, neither did I. I'm also not understanding how it works, I have tried many possible ways. I couldnt find a good blog/article/forupost that explains to me why it returns a ID instead of the 'location'. In the picture I showed the connection between my tables and the formula, as you ...

I can definitely test it out. Thank you so much for confirming this with me. I'll keep you posted on if this solves this on monday.

No. Your dropdown should be bound to the name, as it is. Is the ID column your primary key? Because your form looks right and your error message indicates an issue with the PK field. If the ID field is an auto-incrementing integer and you are submitting new rows via the form, the submit should succeed.

We do have that. Do I need to tie the drop down control to that instead of the Name field?

Your DB admin should make distListID an identity type in the database. Then when the form is submitted, you'll automatically get a unique ID in the DB.