Bob Gajewski
bob at renaissancesiding.com
Fri Mar 28 09:45:55 CST 2003
Susan If you are using autonumber keys, you *may* be able to just use a quick query as your source with the autonumber field set to sort descending ... not very safe, though. You probably should have a date/time stamp field in the many table for LastUpdated with a default value of Now() ... then use a quick query as your source with the LastUpdated field set to sort descending. Regards, Bob Gajewski On Friday, March 28, 2003 10:09 AM, Susan Jones [SMTP:susanj at sgmeet.com] wrote: > I hope this is so easy I'll be embarrassed I even asked, but.. > I have a query that links two tables with a one-to-many relationship. My > problem is that I want to pull only the most current record on the many > side. I know this has to be something easy, but I'm either blind to it or > just not able to figure out where to start looking. I tried to access the > archives, but the link takes me to the mail options page > Thanks! > Susan > > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > >