i want something like below:
table A
codes address
1
2
3
4 GO:0000166, GO:0000775, GO:0000795, GO:0000800
5
6
7
8 GO:0042802
9
10 GO:0005509, GO:0005856, GO:0007010, GO:0016020, GO:0051016
table B
codes name information
1 alex builder
2
3 john IT
4 rupa IT
5
6 lex washer
suppose i hv 2 tables table A and table B. table A is linked to table B by the column 'codes'. i hv the above data all i want is when user gives command for GO:0000795 this word should be searched. the what ever data which is present in table B associated with codes (rupa, IT)should be displayed here search should result in recognition of 4(in column codes) n linking to table B.....
this search should have criteria search only word in all the colums 'address' in table A recognise perticular code n display information of table B associated with that perticular code.
can usage of ASP as front end be of any use???
plz help
thnx again
neha