I have a customer form that grabs information from a paradox table called "customer". This form also has a data grid that lists all the items that the customer has purchased, which is stored in another paradox tabled called "sales".
What I want to do is filter the data grid by customer name, so that when the user navigates through each customer, only their sale information is displayed in the datagrid.
The data grid is linked to a different table object on the form. I've tried to apply a filter to the datagrid already, using:
SalesTable.Filter := '[Customer Name] = ' + '[' + CustomerTable.FieldByName('Customer Name').Value + ']';
But this results in an error.
It feels like I'm missing something very minor.