Hi

I have the following application structure in FileMaker Pro V6

Database 1: Transactions - Fields: Primary key = Transactions_ID with subform linked to Transactions_items - 1 to Many
                                  Primary key = Clients_ID with subform linked to Clients - 1 to 1
                                  Other ordinary fields such as Order_number, Delivery_date etc.
   
Database 2: Transactions_items - Fields: Secondary key = Transactions_ID.
                                        Primary key = Products_ID with subform linked to Products - 1 to Many
                                        Other ordinary fields such as Quantity etc.

Database 3: Clients - Fields: Secondary key = Clients_ID
                             Other ordinary fields such as Name, Address, Contact, etc.

Database 4: Products - Fields: Secondary key = Products_ID.
                              Other ordinary fields such as Description, Price etc.

I read in the documentation about hierarchical import for a main form and it's subform for "natural Link" and I think I understand how it works with a 1 to many set up. Is it possible to apply the same principle but for a slightly more complex structure like this one above?


Tia

Serge

Jondolar,

You can probably set up a simliar relationship in Sesame. The process of moving four interconnected databases from one application to another is not going to happen with a single hierarchical import. Your best bet is probably to bring them in one at a time with relational links, then use the process described in other threads to convert those relationships that are appropriate into natural links.

Serge,

Try this link. See the last post by Hammer (Erika).
http://www.lantica.com/Forum2/cgi-bin/yabb/YaBB.pl?board=archived;action=display...

I think there should be a step 4 1/2, which would read something like this:

4.5) Remove all the records before re-importing the data.

Otherwise, you're likely to end up with duplicate parent form data.

Another word of caution - you should also read this thread:
http://www.lantica.com/Forum2/cgi-bin/yabb/YaBB.pl?board=gen_disc;action=display...

Well, the way I did it, was to import my data into a relational Sesame subform first. And then followed the instrucions that Erika posted to make it naturally linked.

I was thinking along the same lines as Erika's suggestion: Quote: