Mihai Palade \(Bucharest - Romania\)
|
| Posted: 06/28/2002, 8:13 AM |
|
Hi,
I have 3 mySQL tables table1 <->> table2<->>table3 , where "<->>" a relation
"one-many"
table1 : key ID1
table2 : key ID2, REFt1 (points to the table1)
table3 : key ID3, REFt2 (points to the table2)
I have a page which implements:
- a GRID form on table1 where ID1=a specified value
- a RECORD form on table2 where REFt1=ID1 and ID2=a specified value
- a GRID form on table3 where REFt2=ID2
This page has an INSERT to a page where a new record of table3 will be
inserted corresponding to the spoecified ID1 and ID2. My problem is that I
cannot pass the ID1 parameter (IT DOES NOT APPEAR AS A POSSIBLE PARAMETER
because on the table2 I keep just a reference to table2). Can you help me
with this !?
Thank you !
Mihai Palade
Romania
|
|
|
 |
Mihai Palade \(Bucharest - Romania\)
|
| Posted: 06/28/2002, 8:25 AM |
|
Additional information : I need to pass also the reference to table1 , I
mean ID1 because on that page, I also display, somehow like a tree all the
levels till the new info whcih will be inserted.
Thank you !
Mihai Palade
"Mihai Palade (Bucharest - Romania)" <mpalade@hotmail.com> wrote in message
news:afhuf8$db4$1@news.codecharge.com...
> Hi,
>
> I have 3 mySQL tables table1 <->> table2<->>table3 , where "<->>" a
relation
> "one-many"
> table1 : key ID1
> table2 : key ID2, REFt1 (points to the table1)
> table3 : key ID3, REFt2 (points to the table2)
>
> I have a page which implements:
> - a GRID form on table1 where ID1=a specified value
> - a RECORD form on table2 where REFt1=ID1 and ID2=a specified value
> - a GRID form on table3 where REFt2=ID2
>
> This page has an INSERT to a page where a new record of table3 will be
> inserted corresponding to the spoecified ID1 and ID2. My problem is that I
> cannot pass the ID1 parameter (IT DOES NOT APPEAR AS A POSSIBLE PARAMETER
> because on the table2 I keep just a reference to table2). Can you help me
> with this !?
> Thank you !
>
> Mihai Palade
> Romania
>
>
|
|
|
|
|
