InfoPath Dev

I have created a database in access with some lookup fields that has Primary Keys.

I can see the records perfectly in the Access Table, but when I run the Query in Infopath 2003,

It returns the Primary keys instead of the assigned Fields with the data.

Is it possible to have the Data displayed in the Infopath form without restructuring the Database?

Can I make a Query of some sort that will extract the required information from the Database and

I can use this Query as the focal point of the infopath form?

Thanks.

Hi, please only post a question once. If you need to provide more information, please add it on to your original question. Thanks.

I'm responding to your earlier post here: http://www.infopathdev.com/forums/p/7581/27729.aspx