D
dennisW
Inexperienced user but working on fun? database: inventory, 'on order?', 'ID
the recv'd items as orders come in & add to inventory', etc. I hope
eventually to use a switchboard as users won't take time to manually search
database. Starting with "Find Item in Product table". Product table has
both Chemical + non-chemical items, (Y/N field). User chooses Y/N to
filter out the rest. I then need a query to prompt for "search item" in
Product. All non-filtered items should display alpha starting at 1st Name
found so we can still check other item names in Product.
Do I start with a query with the PRODUCT-'Chemical' field only? How can I
then apply a filter based on Y/N reply before finding item? If I then use a
subquery (1st Q applies filter, subQ prompts user to enter item Name, subQ
finds item then lists all (Chemical or non-Chemical) in Product, starting
with 1st found record), what is the syntax? I don't know SQL. (As user
types 1st letter, is it possible to fill in rest of the prompt with item Name
that matches the typed letters; can enter or finish typing as in Excel
lists?) Thanks. Any help appreciated.
the recv'd items as orders come in & add to inventory', etc. I hope
eventually to use a switchboard as users won't take time to manually search
database. Starting with "Find Item in Product table". Product table has
both Chemical + non-chemical items, (Y/N field). User chooses Y/N to
filter out the rest. I then need a query to prompt for "search item" in
Product. All non-filtered items should display alpha starting at 1st Name
found so we can still check other item names in Product.
Do I start with a query with the PRODUCT-'Chemical' field only? How can I
then apply a filter based on Y/N reply before finding item? If I then use a
subquery (1st Q applies filter, subQ prompts user to enter item Name, subQ
finds item then lists all (Chemical or non-Chemical) in Product, starting
with 1st found record), what is the syntax? I don't know SQL. (As user
types 1st letter, is it possible to fill in rest of the prompt with item Name
that matches the typed letters; can enter or finish typing as in Excel
lists?) Thanks. Any help appreciated.