promanron
Posts: 1
|
| Posted: 10/08/2008, 7:26 PM |
|
Hi All,
I would like to know if it is possible to accomplish the following using CCS. I am running the evaluation version, on a win 2000 server, sp4, php 5.2.6, mySQL 4.1 or 5.0.
I have a mysql db with columns such as...
orderNbr, firstName, LastName, lineNbr, partNbr, desc, qty
If an order is placed with multiple line items, the orderNbr, firstName, lastName fields are replicated for each entry in the db. The lineNbr, partNbr and qty fields are unque for each line item ordered...
A12345 Fred Flintstone 1 ABC123X Big Part 10
A12345 Fred Flintstone 2 DEF321Y Engine 33
A12345 Fred Flintstone 3 XXX999B Wheel 12
I would like to provide a web page where the user enters search information, then the common fields, (orderNbr, firstName and lastName) are displayed only 1 time, and the line item information is displayed in a grid. If the user changes anything in the common fields, all of the line item records get updated. If the user adds a new line item, that record gets updated with the data from the common fields. I also want any changes to not take effect until the user 'posts' the changes, just in case they make changes to the incorrect record, and don't realize it until too late.
thanx for any feedback you can offer,
ron
|
 |
 |
datadoit
|
| Posted: 10/09/2008, 5:33 AM |
|
Ron, look at changing your table structure to a master/detail design
versus the existing flat file design.
After doing that, be sure to download the CCS Example Packs, which will
contain examples of master/detail grids and records.
http://examples.codecharge.com
|
|
|
|
|
