swilson
Posts: 84
|
| Posted: 12/21/2005, 11:06 AM |
|
I have a project where the data about one aircraft exist in multiple tables. For example, some specs, such as color, price, aircraft time, and serial numbers are contained in the Aircraft table. Available factory options, which vary depending upon serial number, exist in the factory options table. There is a many-to-many table (AircraftOptions) that records which options pertain to which aircraft. There is another such table for available after-market add-ons. Many add-ons may apply to one aircraft, and many aircraft have the same add-on defined in the AddOn table.
On one page, I want to update the Aircraft table, Options and Add-ons that pertain to one aircraft. Simple listboxes or check boxes won’t due, since I also want to display value and price totals on the same page that result from selected options.
Ideally, I’d like to have multiple grids on one record form. Is the solution to create separate record forms or updateble grids on one page? Then, can one submit button serve to update all forms? And, could I total the value of selected options from one form with the selected add-ons from another, and base price from yet another?
Any ideas are appreciated.
THANKS,
Steve
_________________
It continues to amaze me, how often the solutions to seemingly complex problems are so very simple. |
 |
 |
E43509
Posts: 283
|
| Posted: 01/03/2006, 8:36 AM |
|
I do complex updates using database packages and procedure calls instead of straight sql in the web app. I pass the procedure the data it needs and I let the database procedure do the heavy lifting.
|
|
|
|
magus
Posts: 98
|
| Posted: 01/05/2006, 3:22 PM |
|
Dear Steve,
E43509 is probably right, but depending on the database server version you are using stored procedures may not be available.
To update multiple tables in one form is possible using event code but it is not very pretty. You have to be reasonably confident using CCS to attempt it and be prepared to get your hands dirty.
Sounds like you will also have to use javascript to do the on-the-fly totalling of selected option values.
Regards,
Don A
|
|
|
|
swilson
Posts: 84
|
| Posted: 01/07/2006, 3:32 PM |
|
Thanks for the input. Your advice is helpful.
Best,
Steve
_________________
It continues to amaze me, how often the solutions to seemingly complex problems are so very simple. |
|
|
|
|
