My main form is based on a table (tbl_Transactions).
The form contains a TableView based on a query (qry_Transactions).
The form contains two comboBoxes. Each contains a different query. Both queries are based on fields in the tbl_Transactions table.
The form's purpose: a complex filter. (Thank you for the Simple and Complex Filter tutorials!)
The form works, but I am confused on a few things.
The Query, Records, Table, and View Templates folders contain similar templates (Add Filter, Apply Filters, ...). Which one do I choose? More than one?
If one's main form is based on a table, does one use the Table Templates folder or the Records Templates folder? Or, using the example above, the main form is based on a table and the form includes a TableView based on a query, which one does one choose? Or is this a case one needs this Templates folder for these types of actions and one needs that Templates folder for those types of actions.