<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.2802" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>I am working on a new version of FmPro Migrator
which will convert FileMaker relationships into Valentina
databases.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>It seems like it could be beneficial for Valentina
developers if I converted the foreign key based relationships into Valentina
binary links.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>If I understand the process correctly, it isn't
enough to just create the binary links to the tables, I also need to run a SQL
command to link each of the individual records together by using the LINK
command.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>I need to see an example of how I would link
existing records to the new binary link.<BR>The link command might be:<BR>CREATE
OR REPLACE BINARY LINK ClientToInvoice_lnk ON TABLES ( Client , Invoice ) AS ONE
TO MANY</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>And for example I might have two
tables:</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>Table: Client<BR>PK = Client_ID</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>Table: Invoice<BR>PK = Invoice_ID<BR>FK =
Client_ID</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>I don't know which records are linked in advance,
so it looks like I need to have a SQL command which will read thru all of the
Client records linking them with the Invoice records which match the Client_ID
value in the Client table.</FONT></DIV>
<DIV><FONT face=Arial size=2><BR>David Simpson<BR><A
href="http://www.fmpromigrator.com">www.fmpromigrator.com</A></FONT></DIV></BODY></HTML>