NetTalk Central

Author Topic: Browse - Getting related records and displaying in the same row.  (Read 2715 times)

Pauly

  • Newbie
  • *
  • Posts: 26
    • View Profile
    • Email
Hi,

First post so please be kind.

I have two tables, related by an ID field.
The 'Child' table has multiple records, each with the ID, a date and a time.

What I need to do (and am struggling with) is to display the date and time of the LAST child table record (based on the date and time) related to each browse row.

The child table has a key that contains the parent ID, a date, and time. 

Can anyone please advise an elegant way to do this?

Thanks
Paul  ???

kevin plummer

  • Hero Member
  • *****
  • Posts: 1195
    • View Profile
    • Production Accounting and Software Payroll
Re: Browse - Getting related records and displaying in the same row.
« Reply #1 on: March 08, 2012, 03:48:05 AM »
I think you would need to loop your child table (in desc order) in the following embed to get the last child record .

      ! Start of "Before Table Row"
! [Priority 5000]

The way I do it is to assign the value to a local variable which is part of the browse.

HTH's