Value list for drill down technique question

[skearton]

Hi Gurus,

When a user is to add items to a Purchase Order, I run a script that takes them to a new window in the raw materials table, does a find based on the supplier ID, and shows them only the raw materials we get from that supplier.

They are then able to select multiple items, they want to add and this then is scripted to add those items to the PO.

Some suppliers, may only have a few raw materials and others may have hundreds.

I need to be able to give further filter finds within the found set, based on the default supplier ID, so that the user can narrow down what they are looking for.

I have already created qualifiers for the raw materials (within the raw materials table) based on:

Category

Brand

Sub Category

Supplier Size

Supplier Color

SKU

I'm envisioning the user can select the appropriate item they are looking for through the different drop down value lists in each global field for the above and drill down to what they are looking for.

I know I will need to create a related table occurrence to itself for the raw materials.

Does anyone have an example file of something like this I could look at?

Many thanks for your help.

[VincentO'B]

Do a search on this site for "Dynamic value lists", that should bring up some examples.

Vincent