https://www.infopathdev.com:443/forums/47.aspxFor questions concerning issues in the integration of SQL and Microsoft InfoPath.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/16802.aspxThu, 27 Apr 2006 02:43:16 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:16802taenkarth0https://www.infopathdev.com:443/forums/thread/16802.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=16802I have a problem using infopath with a SQL database at the moment. Let me <br />start by giving a brief example of how my DB is setup<br /><br />tblCustomer<br /> - CustID (key)(one to many relationship with tblCustSiteAssoc)<br /> - CustName<br /> - CustStatus<br /><br />tblCustSiteAssoc<br /> - CustID<br /> - CustSiteID<br /><br />tblCustSite<br /> - CustSiteID (key)(one to many relationship with tblCustSiteAssoc)<br /> - CustSiteName<br /> - CustSiteStatus<br /> - CustSiteAddr1<br /> - CustSiteAddr2<br />.........etc<br /><br />Using this strategy for generating virtually no data redundancy I can now <br />not use Infopath to post to my Database because there is no Primary key in <br />tblCustSiteAssoc which there should not be that I know of. anyone know how to <br />get around this without deleting the linking table?<br /><br />