andreasfc
Posts: 26
|
| Posted: 04/04/2008, 5:43 AM |
|
We want to make a webapplication for a customer but I have some problems on how to get the following working.
We need a few blocks on 1 page
When a customer is found we need the following info
1. Customerinfo (with all info, adres, contactperson)
2. Orders (list of orders a customer has)
3. When activating an order a digital overview of all orders on the harddrive, xls or pdf.
Thanx
|
 |
 |
wkempees
Posts: 1679
|
| Posted: 04/04/2008, 8:47 AM |
|
What is your problem?
This is one page with a login.
on the page a form (customer info) with its record identified by either the logged in customer or the logged in users customer_id Iinsert/update/delete disabled)
on the page a grid, showing the orders, grid's sql should filter the orders(?) table almost the same as above form, by customer_id(?)
the third is a report called by a link, with some output handling to cater for xls and/or pdf.
The questionmarks in this text are present because the database structure is unknown to me.
If this is to function on an existing database, CCS could help you do this fast.
Walter
_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)
if you liked this info PAYPAL me: http://donate.consultair.eu
|
|
|
|
andreasfc
Posts: 26
|
| Posted: 04/04/2008, 9:06 AM |
|
@Walter,
I am used to work with MsAcces, and when using a form I can creat a subform, and then easaly link this to the main form, I have tried this to do before with CodeCharge, but have never been able to accomplish this.
I will try to make an overview of what I want this weekend if this is not clear.
(btw are you fro holland?)
|
|
|
|
wkempees
Posts: 1679
|
| Posted: 04/05/2008, 8:22 AM |
|
Yes, NL indeed.
CodeCharge or CodeChargeStudio?
What version what Database?
The described situation is still 'easy' within CCS.
Several examples available, several simple techniques to reach your goal.
_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)
if you liked this info PAYPAL me: http://donate.consultair.eu
|
|
|
|
andreasfc
Posts: 26
|
| Posted: 04/05/2008, 9:36 AM |
|
@Walter, I am using Codecharge Studio 4.0.0.4.
I know it could be easy within Codecharge, but I am still unable to get is working.
The database should be SQL server 2005, withi IIS on windows 2003.
It should be something like this
Search form for customers, then when data found for the Customer, when clicking a list with orders and information, then there should be another link from there to see a digital order.
Andre
|
|
|
|
|
