Hi,
I'm trying to make a virtual stock store. When stock comes in I want to use an IN form to add it to the database. Then when someone uses stock you go into the OUT form and enter the quantity of stock used. This then updates the database. So to see how much stock we ahve at any time youc an just got to the database.
My question:
The stock is split into various types, eg. DigiBeta tapes, HDCam tapes, HDV tapes, DVDs, BSP tapes etc. you can each of these as various lengths, eg. DBs can be 6', 12' 22' 32' 64' 94' 124' long. So instead of having a dropdown with hundreds of items on I want a first box where you select the type and a second for the length. How do I do this?
That was probably too much detail but at least now it's obvious.
Muchos gracias!
I'm trying to make a virtual stock store. When stock comes in I want to use an IN form to add it to the database. Then when someone uses stock you go into the OUT form and enter the quantity of stock used. This then updates the database. So to see how much stock we ahve at any time youc an just got to the database.
My question:
The stock is split into various types, eg. DigiBeta tapes, HDCam tapes, HDV tapes, DVDs, BSP tapes etc. you can each of these as various lengths, eg. DBs can be 6', 12' 22' 32' 64' 94' 124' long. So instead of having a dropdown with hundreds of items on I want a first box where you select the type and a second for the length. How do I do this?
That was probably too much detail but at least now it's obvious.
Muchos gracias!