dlshad
Posts: 5
|
| Posted: 02/16/2011, 4:23 AM |
|
Dear All
I have 2 tables ,
First one is Personal_info
it has ID = Auto increment
and other fields,
Second table is Services
I have also ID= integer and it's not Auto
into the First page I add the Personal info then when submit , Continue to the other page to add Services.
I made Dblookup (Max ID) into the Second page to bring the ID number from Personal_info table.
I have a Grid into Service Page.
but the Grid show the all entry inside the Service Table.
I need only to show the Result of the ID
Which it's Empty now , but when I insert some data it will only show what I added according to the id I have..
any one can help?
Best Regards,
|
 |
|
chriscripps
Posts: 30
|
| Posted: 02/18/2011, 12:51 PM |
|
I am not sure I am clear on what you are asking, but it sounds like you are trying to do something similar to this example:
http://examples.codecharge.com/ExamplePack/MultiStepReg...trationGrid.php
The write up is there telling you how to do that.
If I am correct, you can pull up the last insert id of your personal info page. I would do that in the after insert event on the first page instead of on the second page. Then, set a URL parameter with that id number to go to the second page.
In the second page, you need to use the parameter set on the first page in the WHERE statement of your editable grid on the services page.
Hope that helps, Let us know.
Chris
|
|
|
|
dlshad
Posts: 5
|
| Posted: 04/13/2011, 4:35 AM |
|
thanks for you..
Done
|
|
|
|
|
 |
|
|
|
