Copy Price script

[Jredeemer14]

I'm trying to generate a script to copy a price from one table to another, it would look something like this (my script lingo is not very good)

If (Inventory[color:red]Sold::Serial Number = Inventory::Serial Number) then copy Cost from Inventory::Cost to Inventory[color:red]Sold::Cost

Any ideas to get me started on a working script? Thanks - Jeff

[T-Square]

You haven't provided a whole lot of detail, but depending on the circumstances, you might use an auto-enter value in the InventorySold::Cost field to supply this information without a script. Assuming a relationship

InventorySold::Serial Number = Inventory::Serial Number

the auto-enter would simply use Inventory::Cost. Then, every time a record got added to InventorySold, the cost would get supplied automatically. Be sure that the Replace Contents checkbox is set correctly, or else you'll always be replacing the value.

If this is not helpful, perhaps you could give us a little more information about why and when you want to copy this field data into the record.

David

[mr_vodka]

Seem like this could be handled using a Lookup on the price field.