InfoPath Dev

I 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?

I 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? If ...