I am trying to find any Applicator for a given Terminal in our database.
Typically, this information is in the Item Master table,
however I have come across a few entries that only have the correct information in the Die table.
The original query listed:
Item -- the item number
Drawing -- ms link to PDF file (See code below for example)
Terminal -- concatenate all fields with terminal info; stripped of spaces, commas, and dashes. Used with like * [entered value] * for WHERE clause.
Description - included to have extra info.
Reference Info - more extra info.
The Die table is mostly compatible, with the exception of the Drawing entry. There is no file link in that table; because it is in the Item Master table.
The end result is always the same:
For some reason, the Union Query causes the link to become text instead of staying as a link. Is this common? Is there a way to fix it? Other than that, the query is working perfectly.
Typically, this information is in the Item Master table,
however I have come across a few entries that only have the correct information in the Die table.
The original query listed:
Item -- the item number
Drawing -- ms link to PDF file (See code below for example)
Terminal -- concatenate all fields with terminal info; stripped of spaces, commas, and dashes. Used with like * [entered value] * for WHERE clause.
Description - included to have extra info.
Reference Info - more extra info.
The Die table is mostly compatible, with the exception of the Drawing entry. There is no file link in that table; because it is in the Item Master table.
The end result is always the same:
Code:
DIE1111, DIE1111#file_location/DIE1111.pdf, 2252912, etc, etc
DIE1111, , 2252912, etc, etc
DIE2222, DIE2222#file_location/DIE2222.pdf, 3658745, etc, etc
DIE2222, , 3658745, etc, etc
