I have text boxes that update a filter table that I am trying to link to a subform. If I link the filter table master fields to the subform table slave fields, then the subform will display records only where all of the slave fields match the master fields, regardless of the SQL command. For example, I have tried:
SELECT ID FROM Table, FilterTable WHERE Field1 = Field1Filter OR Field2 = Field2Filter
SELECT ID FROM Table, FilterTable WHERE Field1 LIKE ‘%’||“Field1Filter”||’%’
But it still behaves as if it says that all fields must match the filter fields. Removing the link between master and slave fields and just simply doing the SQL command doesn’t work either. I am very confused as to how this works and how to make the subform actually display what is written in the SQL command. I am using Libreoffice Base version 184.108.40.206 on MacOS with HSQLDB embedded.