As you can see in the pic of a demo model of MSSQL08, I have a parent with two PKs (wrkr_id, from_dt) and a child with one PK (wrkr_sys_cd_id) and one actual FK (wrkr_id). You will see that TDM thinks that I want my from_dt as part of the FK in the child. I do not. We do not do an equal join on the key dates but a between in the where clause based on a target date.
How can I get TDM 22.214.171.124 to do both the proper PKs at the parent and the proper FK at the child? Thanks.