Effective Dating Tables
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
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.