Hi all.
I'm attempting to create a weekly, day-by-day view of my JOBS file. This sits in an application for an auto-repairer, and represents vehicles booked in for work, for any given week - a kind of basic scheduler / daily jobs record.
My first task was to create the view attached, with 7 browses each showing one day's worth of jobs from the JOBS file.
I achieved this by putting together a set. The primary for the set was my REGISTRATION file (one record only - holds basic licensing data) to which I added 7 hidden date fields (Date 1, Date 2 etc.). The set then features 7 child-table 1-to-Many links - each based on linking the JOBS->Date (child) field to one of the Registration->Dates(1-7) (parent) fields.
Success - I have created my basic layout, and have proved that each browse can display job data for a given day.
My problem now is that I want to display further detail from any given JOBS record (e.g. task details, vehicle make/model/reg no, customer name etc.) in the area below the browses, when the user selects a record from any one of the 7 browses by clicking on it.
I've experimented with conditional sub-forms, and/or using variables which are updated / refreshed as the user clicks a browse .... but basically I'm stuck.
I'm not sure which event to use to kick off the process of fetching the record data and populating the detail area, or which of the above methods (or another) to use.
Your advice would be greatly appreciated as always.
Thanks in advance, Jem
JobsDiary1.PNG
I'm attempting to create a weekly, day-by-day view of my JOBS file. This sits in an application for an auto-repairer, and represents vehicles booked in for work, for any given week - a kind of basic scheduler / daily jobs record.
My first task was to create the view attached, with 7 browses each showing one day's worth of jobs from the JOBS file.
I achieved this by putting together a set. The primary for the set was my REGISTRATION file (one record only - holds basic licensing data) to which I added 7 hidden date fields (Date 1, Date 2 etc.). The set then features 7 child-table 1-to-Many links - each based on linking the JOBS->Date (child) field to one of the Registration->Dates(1-7) (parent) fields.
Success - I have created my basic layout, and have proved that each browse can display job data for a given day.
My problem now is that I want to display further detail from any given JOBS record (e.g. task details, vehicle make/model/reg no, customer name etc.) in the area below the browses, when the user selects a record from any one of the 7 browses by clicking on it.
I've experimented with conditional sub-forms, and/or using variables which are updated / refreshed as the user clicks a browse .... but basically I'm stuck.
I'm not sure which event to use to kick off the process of fetching the record data and populating the detail area, or which of the above methods (or another) to use.
Your advice would be greatly appreciated as always.
Thanks in advance, Jem
JobsDiary1.PNG
Comment