Ivo
|
| Posted: 11/27/2002, 12:49 AM |
|
I have 2 tables:
TABLE: PARENT
parent_id | name
11 Jason
33 Marc
66 Phil
TABLE: CHILDS
child_id | name
111 Jason JR
112 Julia
331 Marcy
661 Johan
662 Linda
663 Collin
I want to make a link from table Parent to table Childs and then show the childs of the parent. If i click on the name Jason the table Childs must show the childs Jason JR and Julia...
I know this database is not perfect but it is not possible to change..
So is it possible to make a link, search, input/output for those tables..
|
|
|
 |
Mike
|
| Posted: 11/27/2002, 6:42 AM |
|
Sorry i don't know? hmmm this must be ease :S
|
|
|
|
Ed Yin
|
| Posted: 11/30/2002, 8:28 AM |
|
add column parent_id in childs table and put in the parent_id from parents table
and that is your url link
sql look like this:
select childs.name from childs ,Barents
where parent.parent_id = chuilds.parent_id
build on woth this info...
with code charge you can use the URL stuff
|
|
|
|
|
