T
themastertaylor
i'm redesigning my ordering system and have hit a problem. basically
i used to have 6 items in my orders form/table, with each item having
the following fields - category, description quantity and rate.
obvioyusly this was restrictive in that i had a 6 item limit. i've
now made the detials of the order i.e. the item rate etc into a
subform displaying as a datasheet to remove this limit. however due
to the number of items in the system i had the category combobox which
then populated the description field with only those items matching
the category. being in a subform this will no longer work as it was
all based around the afterupdate property.
as such i've come up with a work around, i removed the category field
from the form and table, then made my combobox for description into a
dual column combo box showing the category, item and the item id as
the bound and hidden third column. basically i can start to type the
category in and the list jumps to those items and i then select the
item based on the info in the second column. this will work perfectly
for me if i solve one problem. basically once the selection is made
the value visible in my form and table is the category i.e. the first
column from my combobox. i need to keep the category in this column
to enable me to jump to the right part of the list, however i need the
second column to be displayed in the form after selection. is there a
way to do this - it'll be fine if i display both the category and
description or just the description
i used to have 6 items in my orders form/table, with each item having
the following fields - category, description quantity and rate.
obvioyusly this was restrictive in that i had a 6 item limit. i've
now made the detials of the order i.e. the item rate etc into a
subform displaying as a datasheet to remove this limit. however due
to the number of items in the system i had the category combobox which
then populated the description field with only those items matching
the category. being in a subform this will no longer work as it was
all based around the afterupdate property.
as such i've come up with a work around, i removed the category field
from the form and table, then made my combobox for description into a
dual column combo box showing the category, item and the item id as
the bound and hidden third column. basically i can start to type the
category in and the list jumps to those items and i then select the
item based on the info in the second column. this will work perfectly
for me if i solve one problem. basically once the selection is made
the value visible in my form and table is the category i.e. the first
column from my combobox. i need to keep the category in this column
to enable me to jump to the right part of the list, however i need the
second column to be displayed in the form after selection. is there a
way to do this - it'll be fine if i display both the category and
description or just the description