I have a form (invoice) when inserted I would like a trigger to search a table (dr_file_infos) for an image by name which is the invoice number and show the preview on the invoice is their a way to be able to achieve this I can place the images manually but would like to have it done automatically
I have done some key word searches and read a whole bunch of reports on how this could be done but is all very confusing to me
I am very limited in sql and have been able to do a lot from the help that I received form everyone here
SQL 7
The front end is an application named job manager and virtual ticket from Meta-Comm. I know this does not mean much
Any help to get me started would be great
And like I said I have been able to do a lot where Meta-Comm. said that it was not possible because of the help I receive here
Thanks Greg X-)
I have done some key word searches and read a whole bunch of reports on how this could be done but is all very confusing to me
I am very limited in sql and have been able to do a lot from the help that I received form everyone here
SQL 7
The front end is an application named job manager and virtual ticket from Meta-Comm. I know this does not mean much
Any help to get me started would be great
And like I said I have been able to do a lot where Meta-Comm. said that it was not possible because of the help I receive here
Thanks Greg X-)