Parent / Child expressions with timestamp - MAXROW , Select, or Lookup?

[Ms_Margo]

Hi AppSheeters!

I have a parent and child table question and can’t sort out if i should use a lookup, select, maxrow or some combo… Either way - I can’t get any of it to work

Long story short, I want my parent table to list the latest and greatest info from the child based on the timestamp of the child table.

Parent Table:

Parent_id	Key
Parent_lastest_status	Return the most recent child_status based on the Child_timestamp
Parent_lastest_manager	Return the most recent Child_manager based on the Child_timestamp
Parent_lastest_checkin	Return the most recent Child_checkin based on the Child_timestamp
Parent_lastest_checkout	Return the most recent Child_checkout based on the Child_timestamp

Child Table:

Child_id	Key
Parent_id	Reference
Child_timestamp	NOW()
Child_status	ENUM: Store 1, Store 2, Store 3
Child_manager	ENUM: Mgr A, Mgr B, Mgr C
Child_checkin	Date
Child_checkout	Date

Any help would be greatly appreciated

Thanks!