Procedure based on four or more criteria

[Guest]

I'm having trouble wrapping my head around this one... I want to create a
form that gives you a list of matching procedures based on four or more
criteria concerning the part: material type (up to 10 types), material form
(sheet, bar, extrusion, etc.), current grading of part, and grading of part
when procedure is completed. There are thousands of combinations of
procedures, and I want to reduce the possibility of errors. The correct
procedure is critical to getting the correct grading.

I've toyed with nested IIfs, but I think they would be too complex and not
very flexible.

It sounds like what I need is a user defined function, but I'm not sure how
to go about it.

Ideally, I would like a form based on a query that limits your procedure
choices based on criteria in four (or perhaps more) combo boxes. This has
been asked and answered many times on this forum, but I'm having trouble
applying the given answers to my own situation {just so you know what sort of
intellect you are dealing with ;-)} So, if you are willing, please let me
know what you think.

 

[Guest]

Hi

Do the processes "flow". By this I mean that is the material type is say
type A or B would this restrict the number of choice you have for forms. And
if the form was say extrusion would this reduce the choices you have for
grading.

I have never worked at any form of manufactureing database so I may be on
totally the wrong lines here.

 

[Guest]

I don't think it is essential that the selections be restricted in an
AfterUpdate event (if that is what you are suggesting). In fact, all that
may be necessary is a series of parameters on a query which pulls all of
these combinations of data together. But I don't know how to construct it.
(Duh...) The form should act as a calculator based on several different
inputs, giving you the possible solutions.

 

[Guest]

LoL

Yes that what I was going to suggest.

If you are not wanting to restrict the data flow it may be simply a mater of
createing some form of validation (round peg / square hole. etc).

Not really sure how you would do this as don't really understand the problem.

You could try (this is a stab in the dark) createing a query to run the form
and use the afterupdate event of 4 unbound combos to set the value of the
processes in the query. This would give you the option of a calculating the
total cost and of keeping an updateable record of the process.

Not much use this time - sorry - as I said I work in holiday, travel and
event management so all this "making things" is way beyond me. ;-)

 

[Guest]

Thank you so much for your response! It makes more sense to me now that I've
revisited the issue...

 

[i_takeuti]

Thank you so much for your response! It makes more sense to me now that
I've
revisited the issue...