Next Related Record, is this the most efficient way?
Ok in my database i have jobs, and with each job there are site visits, when listing all of the jobs i need to be able to view the next site visit and the reason associated with it, the way i have gone about it is...
create an extra site visits table in the data base, set a global field to get(currentdate)
create the relationship as normal but include date>get(currentdate)
sort related records ascending
in the list of jobs have a related field to the site visits reason, it shows the next one, as the dates are ascending and only showing the ones after today
is this the most efficient way? got the feeling there should be something a tad easier?
Thanks in advance