R
RSCARLISLE
I work at a company that manufactures cartridges, and the tools that they
are used in. In one table (about 3000 records), I have a list of all of our
standard cartridge item codes. This table contains columns describing
features of the cartridge. In another table, I have Tool models listed along
with key descriptors. Some of the descriptors are common in both tables. An
example would be diameter. Both tables will contain a diameter field. There
are perhaps 4 or 5 additional corresponding fields.
What I need to do is, from within the input form for the cartridges, have a
dropdown box with all of the tool models from the other table. I want to
attach all appropriate tool models that will fire that cartridge. Problem is,
each product code will have multiple tools that need to be attached. The
opposite is also true- each tool will have numerous cartridges that work with
it. The preference is to add the tools to the cartridge list, because
(hopefully sometime) the tool list will be complete and not be changed often.
This is the basic problem- to attach multiple tools to a cartridge item.
There are about 1000 tools from which to pick. Given this many tools, using a
checkbox field for each tool isn't practical.
Blue sky wish is to have only the tools that fit a match with corresponding
columns appear in the dropdown list box in the data input form. Only these
tools would be available to select from. An example would be:
Both cartridge and tools have a ‘diameter, ‘category’ 'length', etc. Using
the cartridge record, I only display the tools that have the same
corresponding values. I can then pick from that filtered list to apply the
appropriate tools. That would be the ultimate.
are used in. In one table (about 3000 records), I have a list of all of our
standard cartridge item codes. This table contains columns describing
features of the cartridge. In another table, I have Tool models listed along
with key descriptors. Some of the descriptors are common in both tables. An
example would be diameter. Both tables will contain a diameter field. There
are perhaps 4 or 5 additional corresponding fields.
What I need to do is, from within the input form for the cartridges, have a
dropdown box with all of the tool models from the other table. I want to
attach all appropriate tool models that will fire that cartridge. Problem is,
each product code will have multiple tools that need to be attached. The
opposite is also true- each tool will have numerous cartridges that work with
it. The preference is to add the tools to the cartridge list, because
(hopefully sometime) the tool list will be complete and not be changed often.
This is the basic problem- to attach multiple tools to a cartridge item.
There are about 1000 tools from which to pick. Given this many tools, using a
checkbox field for each tool isn't practical.
Blue sky wish is to have only the tools that fit a match with corresponding
columns appear in the dropdown list box in the data input form. Only these
tools would be available to select from. An example would be:
Both cartridge and tools have a ‘diameter, ‘category’ 'length', etc. Using
the cartridge record, I only display the tools that have the same
corresponding values. I can then pick from that filtered list to apply the
appropriate tools. That would be the ultimate.