Hi,
I have addresses for different persons (One to many) and I keep track of these addresses and add the new address when someone changes his address. I am able to print a report / show all addresses for any person.
Is it possible to have a query that shows the latest address of a person only based on a field name DateFrom. This field (DateFrom) shows the date that person changed his address and moved to a new place.
Thanks
Khalil