form to enter nuts and bolts

[Lumpy]

I'd like to make a form that adds a bolt or bolt+washer+nut or
bolt+washer+washer+nut to a hardware table. I need to be able to sum up the
washers, bolts and nuts individualy on a purchase order later.

My hardware table has fields:
ID Quantity Size Description Vendor Location

It's easy enough to provide individual textboxes for each field but with
bolts we have three comon sceneraios: Bolt only, Bolt+Washer+Nut, or
Bolt+(2)Washer+Nut.

I want option buttons for:
-Bolt only
-Bolt + (1) Washer + (1) Nut
-Bolt + (2) Washers +(1) Nut

If the user selects "Bolt Only" I want the table to be updated with a
single record for the bolt. If the user selects "Bolt + (1) Washer + (1)
Nut" I want the table to be updated with three records, one for the bolt,
one for the washer, and one for the nut. Similarly for "Bolt +(2) Washers +
(1) Nut" only I'd want the washer record to have a quantity of 2.

Any ideas?

 

[Squirrel]

Instead of entering the counts of the hardware components in your hardware
table, could you utilize a lookup table? Then the hardware table contains
text data such as "BoltOnly", "Bolt1Washer1Nut", "Bolt2Washers1Nut". The
lookup table provides the counts to be used via a query when necessary,
these could be the fields/data in the lookup table:

Description Bolt Washer Nut
BoltOnly 1 0 0
Bolt1Washer1Nut 1 1 1
Bolt2Washers1Nut 1 2 1

HTH.
Squirrel.

 

[David F Cox]

I think I would implement this with a little subform with 4 textboxes and
check them in code. I assume that each of these items has its own
description. i.e. different sizes.