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?