Using Set Field function

[Phillip Anthony]

Hello,

I've been trying to use Set Field rather than Copy and Paste script functions but cannot get both the field to be overwritten and the field value that will be placed into the former field into Set Field. I can only enter one or the other. This function obviously needs two fields to operate properly, but I cannot make that happen.

I have seen examples where the author's have used:

Set Field [ "x"; "y' ] or

Set Field [ x; y ]

I am not able to enter either of those by selecting either 'Specify target field' or 'Calculated result'.

Any help will be greatly appreciated.

Phillip

[Phillip Anthony]

I finally figured out how to get both fields into this function. It did not solve my dilemma, but this is a help.

Thanks to all who took a look.

[Lee Smith]

I think you are referring to the data in the fields, and not the actual fields.

In other words,

Set Field (FieldA ; FieldB)

This saying to replace FieldA, with the contents of FieldB

If the fields are X and Y, then you do [color:red]not use the quotes.

i.e.

Set Field (X ; Y)

HTH

Lee

[Phillip Anthony]

Lee,

You're absolutely correct in that I want the data in the fields, not the fields themselves. Thanks for that.

What I am wanting to do is after a given field is populated, I want another related field from that record to auto-populate another like field in a different table.

To make my self a bit clearer: I have two tables 'LineItem' and 'Products' which have all the appropriate linkage based on the correct Primary and Foreign keys.

The 'Products' table contains all the products. The fields in this table are 'Image' and 'Image Caption' plus the necessary ID values for this table and another to match the Primary Key of the 'LineItem' table.

The 'LineItem' table has a single portal field which is populated via a list based on the appropriate field in the 'Products' table. In other words, upon selection of that field, the menu reflects all of the 'Product' values in that field, so all you have to do is select a value (or image caption, really). This portal works perfectly.

Now, what I would like to have happen, is that once this field is populated, I would like the image associated with this caption (from the same 'Products' table record) to auto-populate the Container field associated with the 'LineItem' table.

Any comments or suggestions will be greatly appreciated.

Phillip