InstantForum 2017-1 FinalStrataFrame Forumhttp://forum.strataframe.net/StrataFrame ForumSun, 31 May 2026 02:32:31 GMT20http://forum.strataframe.net/FindPost28218.aspxI checked with Trent, et al and this apparently got overlooked. It is now on the todo/to-test list. I'll let you know when I get more information.Tue, 31 Aug 2010 18:03:20 GMTGreg McGuffeyhttp://forum.strataframe.net/FindPost3538.aspx<DIV class=Section1><P class=MsoNormal><SPAN style="FONT-SIZE: 8pt; COLOR: #1f5080">I’m having a problem deploying a database with a compound foreign key relationship. DDT will allow you define two relationships to set up the foreign key relationship between tables TableAxTableB and TableC in the attached example but fails when you try to deploy it. </SPAN></P><P class=MsoNormal><SPAN style="FONT-SIZE: 8pt; COLOR: #1f5080">-Larry</SPAN></P><P class=MsoNormal><?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p>&nbsp;</o:p></P><P class=MsoNormal><?xml:namespace prefix = v ns = "urn:schemas-microsoft-com:vml" /><v:shapetype id=_x0000_t75 stroked="f" filled="f" path=" m@4@5 l@4@11@9@11@9@5 xe" o:preferrelative="t" o:spt="75" coordsize="21600,21600"><v:stroke joinstyle="miter"></v:stroke><v:formulas><v:f eqn="if lineDrawn pixelLineWidth 0 "></v:f><v:f eqn="sum @0 1 0 "></v:f><v:f eqn="sum 0 0 @1 "></v:f><v:f eqn="prod @2 1 2 "></v:f><v:f eqn="prod @3 21600 pixelWidth "></v:f><v:f eqn="prod @3 21600 pixelHeight "></v:f><v:f eqn="sum @0 0 1 "></v:f><v:f eqn="prod @6 1 2 "></v:f><v:f eqn="prod @7 21600 pixelWidth "></v:f><v:f eqn="sum @8 21600 0 "></v:f><v:f eqn="prod @7 21600 pixelHeight "></v:f><v:f eqn="sum @10 21600 0 "></v:f></v:formulas><v:path o:connecttype="rect" gradientshapeok="t" o:extrusionok="f"></v:path><o:lock aspectratio="t" v:ext="edit"></o:lock></v:shapetype><v:shape id=_x0000_i1025 style="WIDTH: 291.75pt; HEIGHT: 159.75pt" coordsize="21600,21600" o:ole="" type="#_x0000_t75"><v:imagedata o:title="" src="SFError_files/image001.emz"></v:imagedata></v:shape></P></DIV>Tue, 31 Aug 2010 18:03:20 GMTLarry Caylorhttp://forum.strataframe.net/FindPost28212.aspxping...Tue, 31 Aug 2010 12:23:27 GMTLarry Caylorhttp://forum.strataframe.net/FindPost28069.aspxHi Larry.</P><P>I am having a look at this with the guys.Mon, 23 Aug 2010 17:08:03 GMTIvan George Borgeshttp://forum.strataframe.net/FindPost28066.aspxThis is still an issue in the current version. While the DDT will let you define multiple relationships to implement a compound foreign key, the DDT will not deploy it. Also if you try to import a database with a compound foreign key, the DDT will only&nbsp;import the first relationship it sees.&nbsp; </P><P>In the past I've worked around this issue by adding a surrogate integer PK to the parent table that results in a single relationship to the child table but this introduces other issues that Id like to avoid. </P><P>Attached is a simple ER diagram illustrating the relationship I'm trying to implement (relationship 5) in the diagram and a screen shot of the DDT error when trying to deploy.Mon, 23 Aug 2010 15:24:09 GMTLarry Caylor