I¹m building a database, to be used on the Web. It is for a supplier of
foods.
They have a hierarchy of headings, so a product may be:
FROZEN FOODS
Fish and Seafood
Shellfish
Mussels
- where the actual product is Mussels, with a unique identifying SKU of say
F3333, and numerous attributes such as weight, portions, vegetarian,
spiciness etc. So there are up to 3 levels of heading for each product.
I have defined Value Lists for each level of heading (Temperature, Grouping,
Subrange, SkuRange) and they are based on self-join relationships. The new
product¹ layout has each field formatted with a drop down menu based on the
value list.
So when you create a new product, you select Temperature (e.g. Frozen Foods
or Chilled Foods), then the Grouping field offers only those Groupings which
already exist within that Temperature, and so on down.
Is there any way of making this work in a Find? The top level (Temperature)
shows a dropdown menu, but after that the heading¹ fields don¹t prompt the
user.
I want the user to be able to drill down, if they don¹t know the actual
product SKU.
As usual I am probably approaching this from the wrong direction, or
thinking about it in the wrong way!
Any suggestions would be most welcome....
Emma
- -
Fourninety Limited, a member company of the Media Square plc group. Registered
in England No. 3737606. Registered address Clarence Mill, Clarence Road,
Bollington, Cheshire. SK10 5JZ
Confidentiality Notice: The information in this document and any attachments
are confidential. It is intended only for the use of the named recipient. If
you are not the intended recipient please notify us immediately and delete
this document. The contents on this document must not be disclosed to any other
person nor may any copies be taken. The views of the author may not represent
the views of the Company.
Security Warning: This e-mail has been created in the knowledge that Internet
e-mail is not a 100% secure communications medium. All liability for any claims
arising as a result of using this medium to transmit information by us or to us
is excluded to the extent permitted by law.
