So this is may be doable.
You need to know the Record ID# of the most current record
for the current user (I assume that the Key field is Record ID#)
Not tested but make a table and load up up with some users, well at least you. Set the Key field to be userid.
Relate that table to the details table via Record Owner. One User has many poles.
Get the Max Record ID#. Now you know the Record ID of the most recent Pole. Get the data you need up to that record via a summary fields or a reverse relationship.
Then make a relationship to the pole table based on a reference field of current user and look up the info from the last pole.
To self maintain that user table, you can set up an Automation to add a record into the table when a pole record is saved and the user does not exists.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.commark.shnier@gmail.com
------------------------------
