I am trying without much success to display multiple columns from a database where the selected data is dependant on specific common data.
I have tried using an SQL statement with a Jet 4.0 OLE DB connection.
SELECT Name,Date,Action FROM Track WHERE SerialNumber="1"
with the output displayed in a datagrid.
OK, this gives me roughly what I need. However, what I require is the option to define the value for SerialNumber at runtime.
Any assistance at all would be greatly appreciated. Even if someone could point me towards the type of information I should go in search of.