converting FileMaker foreign keys to Valentina binary links

[David Simpson]

I am working on a new version of FmPro Migrator which will convert FileMaker relationships into Valentina databases.

It seems like it could be beneficial for Valentina developers if I converted the foreign key based relationships into Valentina binary links.

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.

I need to see an example of how I would link existing records to the new binary link.
The link command might be:
CREATE OR REPLACE BINARY LINK ClientToInvoice_lnk ON TABLES ( Client , Invoice ) AS ONE TO MANY

And for example I might have two tables:

Table: Client
PK = Client_ID

Table: Invoice
PK = Invoice_ID
FK = Client_ID

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.

David Simpson
www.fmpromigrator.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.macserve.net/pipermail/valentina/attachments/20090216/073e439f/attachment.html