"Bookmarking" a portal row
I feel like this should be fairly easy to do, but I just can't find the right calculation. I have two tables related by a auto-entered serial id number from the main table. The second table serves as an optional list of records that apply only to the record in the main table that matches the id number. In the second table, there are two crucial fields, a date field and a text field. I would like to be able to be able to find and return the newest record from the second field (for each record in the main table) and its corresponding text field into a date field and text field (respectively) in the main table, preferably using calculated fields. Any ideas?