InfoPath Dev

 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 ...

 Hello Hilary, It's a pleasure to get a response from you. Most of my knowledge of Infopath I got from your responses on this forum. I don't really have a formula, it only says d:productnummer (this is the productnumber from the Stocklist). I would like to understand what I'm missing. With regards, Ramon

 I'm sorry, I am using Infopath 2013 and I think it should have been in the sharepoint forum instead of Infopath 2010. Could this be removed to the right forum?

Hello, I'm working on an dynamic stock system on sharepoint with Infopath, but I cannot figure out the cascading fields in Infopath. ( i tought cascading fields was also possible within sharepoint but this area is grey, i cannot select tables?). Anyway, I created 5 tables on sharepoint: - locations - products - users (there is a lookup ...