1 Reply Latest reply on Jan 16, 2012 1:00 AM by raybaudi

    TOP VALUE

    goodkinbrett

      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!!!!!!!!!!!!