AnsweredAssumed Answered

Next Related Record, is this the most efficient way?

Question asked by beckett85_1 on Oct 11, 2009
Latest reply on Oct 28, 2009 by TSGal

Title

Next Related Record, is this the most efficient way?

Post

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

Outcomes