I wanted to ping the group to get some advice on what others would think is
the best way to handle doing a search form like as follows:
Item Number: [comboboxA1] [comboboxB2] [textbox1] [comboboxC3]
[comboboxA4] [comboboxB5] [textbox2] [comboboxC6]
[comboboxA7] [comboboxB8] [textbox3]
Description: [comboboxB9]
[textbox4] [comboboxCA]
[textbox5] [comboboxCB]
[textbox6]
Mfg. Name : [comboboxAC] [textbox7]
The possible values in the combo boxes are:
ComboboxA? ComboboxB? ComboboxC?
[empty] [Contains] [and]
[All] [Begins With] [or]
[Customer Item Number] [Ends With]
[Procurement Item Number] [Exact]
[Vendor Item Number]
This form essentially gives the user the ability to search for parts in our
database by saying something such as WHERE "customer item number contains
XYZ or vendor item number begins with RM" AND "description contains spare or
description contains bolt".
If someone has built similar forms in the past, how did you implement this
so that it would be flexible and extendable for more fields or more
criteria.
Thanks
Chris
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
