Chris__T
Posts: 339
|
| Posted: 05/23/2006, 9:33 AM |
|
I have a search box that retrieves a file number, then looks for that file number in a table, and retrieves information (name, date, etc)
I'd like it to do this:
user enters the file number and hits enter.
searches table2 for this filenumber. if not in there, then searches table1 for the filenumber.
Retrieves data from table1 or 2 and shows on screen.
I'm trying to figure out how to search the table, and if its not in there, try another table. Suggestions?
|
 |
 |
Chris__T
Posts: 339
|
| Posted: 05/23/2006, 11:04 AM |
|
Something like:
if (filenum in table1) then
get info from table1
else get info from table2
|
|
|
|
Chris_T
|
| Posted: 05/23/2006, 11:58 AM |
|
or:
a = search table1 for filenum (select statement to see if it's in there)
if true(a) then
view http://.....Table1record.asp
else
view http://.....Table2record.asp
|
|
|
|
|
