Skip to main content
D
Deb3
Known Participant
July 24, 2006
Question

design decision

  • July 24, 2006
  • 2 replies
  • 236 views
I should have asked this question before I got started. But, taking the project in smaller pieces has helped me learn some basics. Now, that I have started, I'm wondering what would be the best way to do it. I need to create a page that will be a data entry form. The page should allow the user to enter at least 15 jobs on one submission. Each job has a calculated linecost based on selection from a query, quantity, and 5 checkbox options. Each job, with detail and linecost, will update a 'detail' table on submission. The sum of the linecosts, user identification, and order # will update another table.

I've put a form on the page representing data that will update the summary table and form(s) to represent each job on the order. Doing it this way appears to be hard to manage and quite messy. Is there an alternative way? I'm sure there is...And can a novice like myself tackle it?
This topic has been closed for replies.

2 replies

D
Deb3Author
Known Participant
July 25, 2006
For ease of use the users will want to keep their current functionality of 'as few keystrokes as possible' ( we're trying to convert an old MSAccess application into CF). I'm thinking that using an array to reference 15 selects, 2 x 15 textboxes, 5 x 15 checkboxes, plus 15 calculated totals might be a saner way to handle this. I'm concerned that creating a 9 dimension array will limit what I can do in CF because of the lack of information available in this area.
A
Anonymous
July 25, 2006
> allow the user to enter at least 15 jobs on one submission

The words "at least" makes me think of the following approach.
Provide the user with a form into which he can enter data about one job. Click the "Submit" button, which goes to an action page and adds that job to the details table. If this is the first job for the order, update whatever information is relevent in the order table.

Once the database has been updated, CFLOCATION back to the form page. Query the detail table for all jobs for this order and display them (in this case, there's only one). Then display the form below the order(s). This process can be repeated indefinately (more than 15 jobs).

You could get fancy and have a radio button next to each displayed order that brings that order up into the form for editing purposes. You can also show a running total, if that's important.
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices