CodeCharge Studio
search Register Login  

Web Reporting

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

YesSoftware Forums -> Archive -> GotoCode Archive

 Multiple Page form....PK ID is entered by user

Print topic Send  topic

Author Message
Ken Hamilton
Posted: 01/12/2004, 10:33 AM

I have a multiple page form where the end user enters in the Primary Key (Customer Number) on the first page of the form. I am trying to get that number to the subsequent pages of the form. Example:

Page1 CustomerInfo CustomerID(PK)
Page2 ContactInfo ContactinfoID(PK), CustomerID(FK)
Page3 BillingInfo BillinginfoID(PK), CustomerID(FK)

My question is am I even in the right ballpark by doing this and if so how do I get the customerID to flow to the other pages?

Ken
LuckyStar
Posted: 01/13/2004, 2:12 AM

I'll propose to you to use example like in (CCSExamplePack/Multiple Page) it is working very good. You can modify than comparing to your needs.
It is not necessary to pas costumerID through all pages. You can use an automatic generated ID that will stay hidden and also another costumerID for your needs.


Hope it will help

By LuckyStar
Anothersledhead
Posted: 01/13/2004, 9:19 PM

Ken

I just dealt with this problem in php. I don't have the code here but I will post my solution for you tommorrow. You need to set the primary key from your record form on the after insert event via custom code. You then retrieve that primary key on your next form on the before show event of your second page. Your table structure is simailar to mine so things shouldn't change much.

   


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

PHP Reports

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

Home   |    Search   |    Members   |    Register   |    Login


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