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
 
Top