Mihai Palade
|
| Posted: 06/29/2002, 2:43 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
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
|
|
|
 |
Nicole
|
| Posted: 06/29/2002, 3:54 AM |
|
Mihai,
Try to store ID1 in session variable. Even if REFt1 field on the Record form for table2 is of non updatable type (lets say Label or URL) you can create custom session var in form Before Show event. AS for ID2 you can get newly inserted value in After Insert event using PHP function mysql_insert_id(), and store it into session as well.
Hope it helps.
|
|
|
|
|
