Thanks for the help in advance

I received some help awhile back on my first problem. This problem was that once I selected a "Tool Type" from a drop down list, it would provide me with the list of "Tools" in the next cell. Once I select one of those tools it would fill in a few other areas with the proper information.

I know to do this I had to have the "Tool_Type" name and the table that the "Tools" were located named the same.

Is there a way that by selecting a certain "Tool_Type" that it will provide me with a drop down list from another table, outside of the "Tools" table? Say I wanted a table that contained "Tool_Holders" that were only used for certain tool types.

Any help would be great!