2. ASPRunnerPro General questions
  3. searching
This topic is locked

searching

 		10/27/2004 6:50:40 AM
ASPRunnerPro General questions
author

I have a parent table "companies"

I have a child table that contains "tradingintersts" for each company
It is possible to search by a field in the child table "tradinginterest" from the master "companies" table to show only those comanies in the master table that meet the criteria from the parent table, with out the user having to go to the list page for the child table?
I hope this makes some kind of sence to somebody
Sergey Kornilov admin 10/27/2004

Hi,
I guess you can achieve this by modifing SQL query that ASPRunner builts for search purposes (file ..._list.asp).

select * from MasterTable where MasterTable.FK = DetailsTable.PK and DetailsTable.AnyField = 'AnyCriteria'