Copy field data into a join table field I am having trouble trying to paste field data into an

[Robert Moran]

Copy field data into a join table field

I am having trouble trying to paste field data into an ID field in a join table. The DB works without a problem but I cannot past the ID into the join table field after performing the find on the desired records. I tried Replace Contents (thanks weebick) on the found set, which seemed to work but, in actuality, did nothing. Tried set field via script manager but the calculation setup says the table cannot be found even thought the many to many relationship via the join table works perfectly in the system. I can do a control paste into the join table id field and the related record loads beautifully but doing this 6000+ times is a non starter. Any help would be great. Lastly, the join table ID field is a lookup into the source table that contains the ID.

TIA

Bob

[efen]

...I tried Replace Contents (thanks weebick) on the found set, which ...

You seem to be posting on the wrong forum? Weetbicks posts elsewhere

[Ron Cates]

It sounds to me like you may be missing a set Variable step. If you are taking the ID from a record, then going to another record or layout based on a different table occurance you must first capture the ID before making the switch. Ths is done by using the set variable step and then setting the field with the variable.

Set Variable [ $id; Value:_Primary_id ]

Go to Layout [ “New Layout” (YourTable) ]

Enter Find Mode [ ]

...Set your find criteria

Perform Find [ ]

Replace Field Contents [ _foriegn_id; Replace with calculation: "$id" ]

[ No dialog ]

[Robert Moran]

I'll give it a shot. Thank you so much.

Bob Moran

[Robert Moran]

I tried your scrip. As per Replace Contents, your code appears to run but nothing happens. The cursor remains on the field. Any ideas?