On Wed, 2002-07-31 at 11:10, Chris Albertson wrote:
> You are confusing database design with user interfece design.
>
> Making a user enter any kind of code is stupid user interface
> period. Ifthe user is looking for size 11 1/2 shoues he should
> nothave to remember to enter SizeCode='23W-Z47' He shoul be
> able to either select from a drop down menue or enter any of
> "10 1/2", "10.5", or even "10.3 .. 10 3/4"
The query interface will use dropdowns and some autocompletion (like
tabs to complete part names etc)
Sales of course by scanning a bar code... I am only interested in t\ke
storage of the data and would like to know what Andrew meant by 3 codes.
--
*
* Rob Brown-Bayliss
*