Question about checkboxes

[Joshlindsay]

Hi there,

I'm working on redeveloping my companies quotation and job system.
Currently we're quoting in excel and manually enter the data into an access database which populates the quote letter and then converts it through to a job. The goal is to move the full quoting process in to Access.

We're a printing company and no 2 jobs are the same so we'd need a broad range of options.

From a UI point of view I like the idea of using combo boxes for the lookups and checkboxes for the yes/no fields.
However I'm stuck with the concept behind getting my checkboxes on a form to work.
Ideally I'd like to check a box in the form for "creasing" which would add the EstimateID plus product ID and details for creasing to the TblEstimateProducts table.

I've been trying to figure out how this would work as a checkbox can only have a value of 0 or -1 not the ID field.

Below is how the tables could be made.

TblEstimate - ID, Name, Description, Quantity1, Quantity2, Quantity3,
TblEstimateProducts - ID, EstID, ProductID, ProductQuantity, Price
TblProducts - ID, Name, Price, Units, Minimum, Category

Another option is it could also be setup with a table as follows but I'd need to get the pricing etc from a products table based on if a field is checked or not.

TblEstPrinting - ID, EstID, PrinterID, SectionName, PaperID, TrimSizeID, Bleed, MergeFields, XMPieSetup, Trimming, Packing
TblEstFinishing - ID, EstID, Fold, Crease, CreaseFold, Handline, Collate, Stitch, Trim, Laminating, Binding

Attached is a screengrab of the form we've built.
This is saving the data in the table like the second example above without being able to access price information.

Any help you could provide would be much apprciated.
I'm sure I've explained this really badly so if you'd like anything clarified please ask.

 

[gemma-the-husky]

if creasing is not just a true/false - if there are creasing options - multi-crease etc etc - then you need a drop down to pick the "crease type", I would think.

i don't understand why selecting a type of crease should cause data to be inserted anywhere though. the creasing is surely just an atribute of the job.

you ought to consider the data structure carefully, before you start.

 

[Joshlindsay]

Thanks for the reply Dave.

In my scenario a printed piece would either need the finishing item or not as we've got a machine which you bung it through making it no different for 1 or 10 creases.

Wouldn't the selections for an estimate need to be stored inside a table so that a price can be calculated?

We started setting up a mockup system using my second example from earlier where each controltab inside the estimate form has a table associated for it which would be either filled with the IDs from the combo boxes of the value of the checkbox.

Yesterday afternoon I realized that we're not able to get the product pricing if we go down that route unless we had a tblProducts however I'm not sure how to get the price for an item if it's the field is only marked with a -1.

Cheers