Cannot create a Form with a Query as the Data Source

Hi all. I want to display a form showing four fields of a filtered query “MyQuery” from the table IUser. But once the application is running and try to open the form, I always get the following error “No primary key defined for datasource: MyQuery”. Thanks for your help.

Hi Jean,

Since your form is using an SQL query as a data source, the primary key needs to be specified through the indices tab when you are creating a query.

Click on “Indices” and then give it an ID for your reference and in the key type select primary key

Now click on “Index Fields” and select the primary key (iUser key in this context) and your form should work

Hope this helps!

1 Like