-
Purging Job History
I want to delete all main JobDockets records and its child tables) if these exists before a given date (6 years approx) based on a date keyed into a delete for this date fieild (DeleteDate!…
-
View sort on 2 columns ?
Silly Qustion I want to sort a Jobs tables view by 2 columns Ie First by 'Customer' the that list odered by 'Date' in reverse Individulaly both are easy but I can't sort 2 headers to become one if…
-
Last (or First) function breaking down?
I have a slight issue with getting the last (or first) job date from a child related table Parent table is 'Customers' - Child table is 'JobDockets' So I have a view that shows all the jobdockets in…
-
Dashboard - limit to single record?
Having got along quite nicely without one for a couple of years. I now require a dashboard! so assuming i have this right - I created a seperate table, added new a record and to the form added in the…
-
Print layout - Display of subform quote prices - vertical layout?
I have a quote layout that is printed to PDF. I have been using it for qute a while but am really not that over emanored with the multi (subform) pricing grid layout So the body section (subform) has…