Silvia
|
| Posted: 05/15/2002, 10:15 AM |
|
I'm working with ASP&templates and Access.
I have one table town and another table event in which I have town_id field linked to table town.
I search town and want to display the results in a grid form "Event" based on table event.
I need some SQL in the grid form properties, right? What would that code be?
Also, do I need to define the town_id variable (in before open?), since I input it in the form "Event"? The code would be much appreciated!!
|
|
|
 |
Nicole
|
| Posted: 05/16/2002, 1:46 AM |
|
Silvia,
since you search on town, do you search on town name let user enter town name in text box? In this case you really need some custom code to lookup corresponding town_id and add it to WHERE clause of select events query. Let me know if you use this type of search and I'll try to help you with the code
In case you allow select town name from listbox, then I suppose town_id is passed from the search form. In this case just add it as Input parameter to event grid form.
|
|
|
|
|
