The Progress window does what you describe when it is performing a process where it does not know how long it will take, and therefore cannot show you a percentage. How long did you give it before killing it? If you have a lot of existing records, it has to go through them all and add the new subfield, as well as deleting any existing ones that you removed.

I can't tell unless I see it. Unfortunately, killing the process during a Reconcile gives it a good opportunity to corrupt the db for doing so. If you want to send your dsr into Support, we can see if anything looks evil. What version are you running?

Serge,

All I can see from what you sent me is that the db is blown because Sesame was killed while actively writing out the file. The dsr has some oddities in it, but I can't tell why. Do we have a "known good" that I can use for comparison to see how things are meant to be?

Also, have you ever added fields to this app using Field Manager?

Hi Erika

We obviously don't understand each other. Perhaps my posting is confusing. My database Orders and it's single form Order_Form,  do contain a subform relationally linked to the form Client_Form of the Database Clients..

My second point was that when you add a record in Orders database, with the Natural link approach, The cliend subform does not show the data (unless my set up is faulty).

Anyhow. I will redo 2 streamline applications one with relational link and one with natural link. during the weekend and repost.

Regards

Serge

Hi Erika

Trough experimentation, I finally learned that a subform is bound to a subrecord and if not needed anymore, the subfield should be deleted in the Field Manager and not directly on the main form in order to remove everything.

As for the Natural linking, here is what I did:

Created one Application (SergeDB_Nat) and 2 databases (Orders and Clients) each database having a single main form. Orders has a single LE: Client_Id. Clients has 6 LE: Client_Id, Client_Name, Client.Addr, Client_City, Client_Pc and Client_Contact.

Used Natural linking through a subform on the Orders database main form. The choice for step 3 of Subform Settings is "Make Natural Child Records." The other choice "Show existing Natural Child Record" is not available. There are no "Pre-existing relationship" as discussed on page 141 of the User Guide.
I then did a "Hierarchical import" in the database Orders. Records appears as they should in both databases. So far so good.

When I add a record to the database Orders using Order_Form in Sesame Manager and fill in Client_Id, the details (all the 6 field values) from the corresponding Clients database (same Client_Id) do not fill the Subform on Order_Form. If I do the samething with an identical Application but using Relational Linking, and importing the data separately in each database, the corresponding details in the Clients database fields populate the subform on the Orders_Form automaticaly (as long as Clien_Id has a matching record in Clients).

I can send you the naturally linked App if what I describe here does not appear to be normal behaviour or if I misunderstand something.

TIA

Serge