https://www.infopathdev.com:443/forums/39.aspxNew to InfoPath? Search to see if your question has already been answered. If it has not, then ask it here or the appropriate topic forum.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/3871.aspxMon, 22 Jan 2007 19:59:19 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:3871flippant90https://www.infopathdev.com:443/forums/thread/3871.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=3871I have since realized that I can import multiple tables and make and perform a sql query on these before creating the connection. However, this also results in the same errors. How am I to ensure that only "selected" entries are available for entry?https://www.infopathdev.com:443/forums/thread/1809.aspxFri, 19 Jan 2007 20:13:59 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:1809flippant90https://www.infopathdev.com:443/forums/thread/1809.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=1809I am creating a new InfoPath form from a Data Connection. I am selecting a query as my table. When I do this, I get an error saying that "Submit status: Not allowed - One or more of the tables in the data source do not have a primary key, unique constraint, or unique index." Does this mean that I cannot use a query as my data connection?<br /><br />If so, what should be my solution? I was using the query to ensure that I only got relevant entries (those that have the attribute "selected" as "-1").<br /><br />If I can use a query, then why the error? Each of the tables has the same primary key, is this an issue? I tried adding a unique primary key for each of the three tables involved in the query and this changed my error to "Submit status: Not allowed - A SQL Join statment was used." Well, isn't that what all queries are?<br /><br />Thank you in advance.