Field exchange not working

HiI am using this really good feature to show views from other (source-) databases in my pricipal database. Now I would like to compose a document with the values from a document from one of those views in my principal database. The view action is on the view of the source database an it does open a new document with the right form of principal database, but the fields are empty. The fields have the same name, are computed, the disable field exchange property is not selected but it will not work. Is there something I missed?

cti

Subject: Field exchange not working

You have to set the fieldnames also as the default formulas for the fields.

Subject: RE: Field exchange not working

Forgot to mention it. I did it. Is not the solution.What else could I try?

cti

Subject: Field exchange not working

Have you set the “Formulas inherit values from selected document” checkmark on the form properties?

Subject: Field exchange not working

The only way I have got this working is to set up the following:

  1. create a @dblookup view in the source database taht can be called on

  2. use picklist to make the document selection

  3. use @Dblookups to grab the values from those docs

  4. Use @setfields on the new doc

example code:

temp0 := @PickList( [Custom] : [Single] ; “” ; “SomeView” ; “Choose Record”; “Please select the document from the view”; 1);

temp1 := @DbLookup(“”:“NoCache”; “”; “SomeLUView”; temp0; 2);

temp2 := @DbLookup(“”:“NoCache”; “”; “RSomeLUView”; temp0; 3);

temp3 := @DbLookup(“”:“NoCache”; “”; “SomeLUView”; temp0; 4);

@SetField(“field1”; temp1);

@SetField(“field2”; temp2);

@SetField(“field3”; temp3)