Data lookups

[Jayman]

I am Setting up Infopath with data connections to Access to collect data from
a number of our Production related forms.
I am having a problem setting up a field that will automatically assign a
form number based on the last "form ID #" generated. THis is also my key &
linked/relationship field beteewn tables.

Does anyone have any suggestions?

 

[Clay Fox]

Hi Jay.

Are you getting a specific error?

I would recommend investigating switching from Access to SQL Express. This
makes working with keys and table relationships easier IMHO.

I also would recommend the Database Accelerator. If you are working with
backend Databases it can make your work a lot easier since you do not have to
conform to InfoPath's default DB rules and you have more tools to work with.
Check it out at http://www.qdabra.com
--
Thanks

Clay Fox

Qdabra Software
http://www.qdabra.com

InfoPathDev.Com
The Largest InfoPath Forum in the World
http://www.infopathdev.com