how many access tables can be extracted for an Infopath forms ?

M

Ma-needs help

I am trying to create a Infopath 07 form using data from 10 different Access
tables.
I can only have it work for 1 table.
It should be working for at least 2 looking at the demos, but I can't seem
to get it right.
Is there a special way to create relationship, the standard Wizard doesn't
seem to work ?

Does anyone know where I can find a sample with a real Access DB with 2
tables that works ?

Does the Access DB need specific rules or key identification ?
Any help is greatly appreciated.
 
S

superbovine

What I find easier is to do my query in access then add it as a secondary
data source, that is of course if you are not submitting back the db.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

InfoPath 2013 crashes when trying to connect to Access 2016 DB 0
Access 2013: Form problem in reading data tables; relationship one-to-one 0
Import many Access tables into Infopath 0
Query data from Access, using an Infopath form 1
Infopath 2007 user cannot Open forms (with access db connection) 1
Using Infopath to create a form based on many-to-one tables 0
Creating InfoPath forms programatically using VSTA ?? 1
On Infopath, do all the Access tables need to be directly related? 4

Top