Discussions

 View Only

Using a non-key field for a lookup? And/or Choosing a single record from a table based on other criteria...?

  • 1.  Using a non-key field for a lookup? And/or Choosing a single record from a table based on other criteria...?

    Posted 01-29-2018 18:02
    So this may or may not even be possible but I'm trying to see if anyone else has experience with anything similar.  Essentially I'm trying to setup a table that will find the oldest record within a table, based on a common field between the two tables(non-key), and then pull that oldest item's key field over into another table.  I know this cannot be done directly between the two main tables since I'm not directly referencing the key field of the parent table, so I tried creating another in-between table that will show any related items that have that common non-key field.  This is doable, but I have no way of then pulling the oldest key field into another table from there, the best I can do is take a look at all the related items that show up in the report, sort by the date, and get the key field value manually from there.  Does anyone have any ideas on how this might be achieved?