4 Replies Latest reply: Oct 24, 2018 4:13 AM by Kingsley Hoare RSS

    Get Item Status at particular time

    Wanyun Yang

      I have two tables:

      Item table with: Item, OrderDate

      ItemStatus table, which has item status change information :

      Item, StatusChangeDate1, OldStatus1, NewStatus1

      (If status has changed multiple times, may also have: Item, StatusChangeDate2, OldStatus2, NewStatus2)

      I'm trying to link these two tables together. By selecting an OrderDate, I want it give me the item status at that time.

      How should I build the model? Any advice helps! Thank you in advance!