I am having some difficulties copying data from a field in a related table to a field in a layout we use.

The script creates a new record in file-A, populates field-1 with a new number, then opens file-B, the next step is to create a new record in file-B (file-B has only two fields), populate field-x with a new number, then set field-y to a serial value from field-1 in file-A.

Unfortunately, the set field command is not copying that information and placing it in field-y in file-B.

Any ideas???

Thanks,

Dave

well it doesn't sound like you have a relation in there

what is the common key feild...maybe that is your problem

Please forgive my lack of understanding, but how do I determine what my key field is?

Vich,

Thanks to your post, I was able to identify that the way the script was originally created was incorrect. I cleaned up the key field and added a portal to bring some data back to the original file and now it is working. The only glitch is that the portal waits until I create a new record to fill in the information for the last record. Kinda weird...

Thanks,

Dave