I have a pricing file with columns:
Model, Type, Mount, Ratio, Data, Description, and Price. =20
I am trying to define a configurator for my client. The company makes a
product that have a multitude of combinations and they are displayed in =
the
part #. Think of the VIN on an automobile defining what MFG, Plant, =
Model,
Year, Major-Accessories are part of the finished product. =20
Model is the primary filter "442"
Type is the secondary Filter "Input Gear"
Mount is my newest problem.
Ratio is the other problem.
Data is the ASPCET of the part that is VERY IMPORTANT.=20
Description is 60% usable and 40% empty.
Price is what I'm after.
This is all meta-data driven in the interface because there are 4 types =
of
product that this beast has to deal with. That is defined off the =
Model.
All '442' will have 8 total options to derive a finished product. All =
520's
will only have 4 for a total product.
The whole part break out is as follows.
Model - Mount Type - Gear Ratio - Input Gear - Lube - Shifter - Assembly =
-
Output
The current issue is limiting the Input Gear to display only the proper =
data
and not duplicates. =20
Some models have a combination of Mount Type + Gear Ratio =3D Input =
Gear.
Others are only Gear Ratio =3D Input Gear. =20
Of course I have to catch exceptions like if Mount Type =3D "A" and Gear =
Ratio
=3D"X" Input gear SQL would be:
Select <fields> from table where Model=3DDropDown1.Text and Mount =3D
DropDown2.Text and GearR =3D DropDown3.Text. =20
But if if Mount Type <>"A" << only by SQL Can I get this listing=20
Select <fields> from table where Model=3DDropDown1.Text and GearR =3D
DropDown3.Text
Any ideas on how to do this all via meta data? =20
We just found this "OBTW" in testing. I had the one additional column
part-picker done, but two columns is getting ulgy. I did the first by
running the data to another hidden dropdown for Distinct's and using =
that as
a pre-fill for what I displayed to the user. I don't want to pull =
another
DD-list out of my ass to do this, so I was hoping to see a different way
through discussion.
And yes this is FoxPro Data! =20
=20
Stephen Russell
S.R. & Associates
Memphis, TN 38115
901.246-0159=20
©2004 Stephen Russell |
