How do I reference a Navision database in InfoPath '03?

[Jason]

I'm trying to put together a form in InfoPath to make quoting our products
faster and more consistent. My company uses Microsoft Navision and I'd like
to be able to import cells from Navision to use as values in my drop down
menus in InfoPath. (so we can select the size of raw material we are using).
The costs for the material change slightly every time we make a purchase
and Navision tracks that, so I want my quotation worksheet to look at the
current values.

Unfortunately I can't find any information (that I'm able to understand) on
how to make this work.

I'm using the office 2003 package and the Navision version is 4.0sp2. I'm
not a programmer by any means, but can follow simple instructions if anyone
can shove me in the right direction.

 

[Clay Fox]

Hi Jason.

I am not that familiar with Navision. However, if it is Microsoft, I am sure
the information could be tapped with the help of SQL. If it uses a SQL
database the forms could access the information directly. If not then it
could be interfaced with SQL via another standard connection.

If you would like to see an example and discuss let me know.