InfoPath Dev

I hope none of you have spent time on this as I found the issue and it has nothing to do with collation. one thing I forgot to mention (and at the time did not think it mattered) was that there are two colums more in the product table Admin_Margin and Margin. Both these have percentage values in decimal like 0.05 and 0.2, and that ...

Hi, Im relativly new to Infopath 2013 but Im very used to coding against databses, I have a wierd issue with my info path form. When it displays a number from the database it offsets the decimal by two, basically the value in the database 17499.00 is shown as 174,99 in the infopath form. Im using the SQL Database to populate drop-down ...