List with aggregate function opens blank edit form on edit

Anton-du-Plessis

I have one form with is a list of records. Click on row opens the edit form with data ready for edit. But, I added an aggregate column to show count of child records. After adding that one column, the edit form does not seem to work as expected. The list still shows the records as before and the count column is also correct, but click on the row opens a 'New record' form instead of edit; completely blank and it behaves like that too, enter field values and save creates a new record that can also not be edited.

I am sure I am doing something wrong but do not see anything obvious to add to the form/field properties.

PS. version is 3.8.3

lsw-fabian

Hi @Anton-du-Plessis,

this happens if REI3 can not determine which dataset should be opened. You have to be careful when using aggregations.
A much simpler way of achiving this, is by using a sub query which you can point to your child records and aggregate the returned values. You just have to filter the subquery correctly so that e.g. an id from the subquery is matching with the main query

Anton-du-Plessis

Thanks, that works, but got another error. Will raise new issue.