Hi All. Sorry about the title, I forgot to change it, but...
Just another little one. I create a Dashboard for my main table, Jobs. I also make a dashboard for the jobs table.
So I have this in the Dashboard
And This
If in the dashboard I search for a data entry, and I select it, I get this error?
Any reason why please?
Your Select statement for Job_no field maybe more than 256 characters depending on field type see (trigger error 256 on your error message) . and the and statement at the end of your query doesn't do anything ( , as you see it stops there.Also your query is looking for data instead of field name it looks like . Better to print query on page or use debugger like firebug or go to appsettings in your output file and change debug to true then run query on your website to see where query breaks. Note you join does not have .tablefor each field for joins. It is usually required but you start new select so it should work.
Also you added edit and add pages to the dashboard make sure that both tables has permissions set correctly for both tables to accomplish add/edit if using permissions . Try without to make sure.
