I am porting an application over from Access to FB 11 Advanced... Here's my question:
Table "AB3_ADD" contains addresses and the date that it became valid.... It's related to table People containing names... Each table contains a unique ID # that appears in both tables.... So, the ID # appears only once in the People table, but multiple times in the Address table. The address table contains every address that each person in the People table. I want a -- excuse Access-speak -- query that only returns a person's latest address.
How the heck do I do this in FM?