Help with Related Records/Lookups....

[supercram]

Hello,

I have 2 databses, A and B.

A single record in Database A has several related records in Database B. The key field in Database B is the date.

I want Databse A to display information from the *most recent* corresponding related record in Databse B. What I have done is made lookups in A but right now they are displaying information from the *oldest* related record in B. The script I wrote does a relookup whenever I push a button and I would like the script to get the info from the most recent record in B.

Any thoughts on how to achieve this with Scriptmaker?

Thanks,

Cram

[stanley]

Supercram:

Welcome to the Forums.

Go to your Relationships diagram and double-click on the box (it usually has an "=" in it) in the line showing the relationship in question. Down at the bottom in the resulting dialog box, you can elect to sort the related records. The default is in ascending order, and I believe you want descending order. It can be a bit confusing at first, but a bit of playing around should give you the result you want.

-Stanley

[RalphL]

The last function will do what you want. Last ( Relationship::Field)

[supercram]

Thanks guys! This is one of the most helpful forums I've ever posted to.

Cheers,

Cram