get latest record

[ChiSao]

Hi, I'm not able to solve a simple problem, due to my lack of experience.

I have tree tables:

Table1 --< Table2 --< Table3

I would like a button on layout1 (table1) which looks for the latest record on table2 MAX(table2::Date) returning the ID of this latest record.

Or in other words:

GET/RETURN table2_id where Max(table2::Date)

Why?

With this button I would like to create an new record on table3 which is related to the latest record of table2. So I need to know the table2_id

Thx for any hints

by

ChiSao

[LaurenKuhlman]

Sort your relationship. Double-click the line between the Table 1 and 2 in the relationships graph and choose the sort checkbox on the child table. Sort by date descending. Then, just call Table 2::ID from the context of Table 1.

Hope that helps!

[ChiSao]

Thanks a lot!

[LaurenKuhlman]

You are super welcome! I am not sure if your name refers to martial arts of the city of Chicago. I flipped through your other posts and think you would really get a lot out of CAFDA or another FM users group if you are not in Chicago. Check it out at CAFDA.com and good luck with your learning!