Drill Down Search
I want to create a series of searches that result in drilling down to 1 record.
I started with a Recordset - Select All
I stepped through the Data Assist Search Wizard, selecting each of 4 tables that pull from a particular column.
My ultimate intent is that selecting Province, will narrow the cities in the second list box by province and further down the sort but what I got was 4 empty list boxes on a new search page.
Will Data Assist do what I want in this case?