Submitting data to properly formed database not allowed?

T

Taen Karth

I have a problem using infopath with a SQL database at the moment. Let me
start by giving a brief example of how my DB is setup

tblCustomer
- CustID (key)(one to many relationship with tblCustSiteAssoc)
- CustName
- CustStatus

tblCustSiteAssoc
- CustID
- CustSiteID

tblCustSite
- CustSiteID (key)(one to many relationship with tblCustSiteAssoc)
- CustSiteName
- CustSiteStatus
- CustSiteAddr1
- CustSiteAddr2
..........etc

Using this strategy for generating virtually no data redundancy I can now
not use Infopath to post to my Database because there is no Primary key in
tblCustSiteAssoc which there should not be that I know of. anyone know how to
get around this without deleting the linking table?

Thanks,

Taen Karth
 

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

Submitting Modifications to Previously Submitted Forms 0
On Infopath, do all the Access tables need to be directly related? 4
Need repeating section, 3 fields submitted, 4th auto-filled and hi 2
infopath problem submitting "the form does not contain any new data"- overwrites my change 0
Submit records to related tables 2
Query not selecting correct records - returniing all records! 0
What are table attributes that prevent Submit to ->Database? 0
Form to submit data to Access Database 1

Top