AnsweredAssumed Answered

TOP VALUE

Question asked by goodkinbrett on Jan 15, 2012
Latest reply on Jan 16, 2012 by raybaudi

Title

TOP VALUE

Post

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?

 

Thank you!!!!!!!!!!!!

Outcomes