AnsweredAssumed Answered

Effective Dating Tables

Question asked by aammondd on May 17, 2011
Latest reply on May 17, 2011 by philmodjunk

Title

Effective Dating Tables

Post

Im fairly experienced with FMP and looking for some advice on how to setup effective dating in tables and manage them in protals.

The general sql that adds effective dating to most views

 

slect fieldnamesfrom said table

where criteria

and EFFDT = (Select (Max(EFFDT) from same table alias1

                   where EFFDT <= Sysdate )

and EFFSEQ = (Select Max(EFFSEQ)  from same table alias2

                   where alias2.EFFDT = EFFDT)

 

Im trying to figure out how to represent these as relationships and for some reason im drawing a blank.

Outcomes