hello there!

may i describe a problem in its reduced form - i work on this since hours with no success.

there is a main database A and a related database B. A and B are related by the field "key". I want a script to copy the content of a field of the active record in B to a field in A.

this does only work when i try to copy the content of the field "key". if a attempt to copy any other field, i receive an emtpy field as result.

what the hell is the problem - i am really at the end of my good mood!

thanks to anybody who has an idea,

bernhard (imz)

Kind of hard to diagnose without seeing the patient. Show us the script you are using and all the definitions for the fields involved.

Set Field(FieldInA, Relationship::FieldInB)

should work fine, there is no known bug.

-bd

Dead, dead easy: Your secondary File ‚b’ is not finding a related file to copy to in ‚A’.

Check your relationships.

Are you using a script in ‘b’ to copy to ‘a’ or a script in ‘a’ to copy from ‘b’? Your described structures are unclear, but somewhere you are not giving FMP the relationship information it needs to know i.e. copy from which field in which record to which field in which record.

Give us more info

Create a portal in "A" that shows the related records for "B". Make sure the relationship is sorted so that the record on top is the one from which you want to pull the info.

Create a script in "A" that sets the import field to the contents of the related export field in "B".

*******************

Alternate method:

Make sure the relationship works both ways.

Now create a script in "A" that pastes to the import field (never mind paste what -- it'll be pasting what we copy to the clipboard).

Create a script in "B" that: Copies from the export record (guess what gets pasted), goes to related record, and performs an external script -- the script we just created in "A".

******************

Either way will work; depending on how you want to get things done. Actually, you can have both, so that you can work either way based on your whim of the moment.