Export Question

This topic is locked

Export Question	4/6/2006 12:01:48 PM
ASPRunnerPro General questions
N npala2001 author I am running a database that has multiple tables, but that are tied together by a unique number. I am wanting the abililty to export all the information that is tied to this unique number. The main table is where I would want to give the user the ability to export by selecting an entry. So a user could select a entry (main_tbl) then select the export button and the ASP script would look at all the other tables and grab all the other data that has the same unique number. Some tables have multiple entries for the same unique number. Table Breakdown All the tables contain related information main_tbl first_tbl second_tbl third_tbl Thanks, Nick


	Sergey Kornilov admin 4/6/2006
	You can use INNER JOIN query to pull data from several tables simultaneously. Probably you can design this query in MS Acsess, save it there and use this query as a datasource in ASPRunnerPro.