CodeCharge Studio
search Register Login  

Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> ASP

 How to Initialize Grand Children Display

Print topic Send  topic

Author Message
muhd fauzi
Posted: 02/23/2004, 9:41 PM

I've built a form with 3 grids.
1. Parent - customer - pk is custkey
2. Child - order - pk is orderkey and fk is custkey
3. grand children - order details. fk is orderkey

The issue is when ever I changed customer, child will change to correct
customer, but order still display details from previouosly selected order.
How do I change/init the detail grid when ever I change customer.

Note: I already set the defa key to -1 whenever there is no para passing

tia

peterr


Posts: 5971
Posted: 02/26/2004, 2:25 PM

Selecting a customer cannot automatically select the correct order or order details because there can be many orders for one customer. Therefore you need to allow your users to select the specific order, not just a customer.
Refer to our "Master-Detail Form for Order Entry" example in CCS Example Pack.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com
View profile  Send private message
Colin Mckinney
Posted: 02/26/2004, 6:30 PM

Is it possible to be able to select customer - and have the detail grid show all past orders only for that customer?

Or better - select customer - search by date - and be able to add data for that customer?
muhd fauzi
Posted: 02/26/2004, 6:53 PM

Yes, I know that, maybe I'm not being clear on this. But I manage to solve
the issue by:
1. Use post/get
2. remove param from url which related to grand child selection when user
select different customer. Also to remove page number parameter in parent
link grid.

thanks
"peterr" <peterr@forum.codecharge> wrote in message
news:6403e724c60d31@news.codecharge.com...
> Selecting a customer cannot automatically select the correct order or
order details because there can be many orders for one customer. Therefore
you need to allow your users to select the specific order, not just a
customer.
> Refer to our "Master-Detail Form for Order Entry" example in CCS Example
Pack.
> _________________
> Peter R.
> YesSoftware Support Representative
> http://support.codecharge.com
> Warning: I use Google and CCS Docs/Examples in most of my answers
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>


Add new topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

MS Access to Web

Convert MS Access to Web.
Join thousands of Web developers who build Web applications with minimal coding.

CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.