hello all,

i am using FMP 8.5 advanced, windows xp.

i have a REAL problem. i am on a job in houston, texas where i want to create a new record and copy the data from my edit area and populate the fields in the new record.

i have created two dummy db's, dummy1.fp7' and 'dummy2.fp7' to demonstrate the problem and i have attached them for review in 'dummy1.zip'.

there is nothing malicious about these.

when i create a new record and try to read a field from the first Db and paste it into the new record via a script, nothing happens.

i have tried 'Set Field', 'Copy' followed by 'Paste' and i have used the script debugger to view the fields all to no avail.

if i do an 'Insert Text' it works fine.

I am stumped. i have made a script in dummy2 called 'makeNewRecAndInsertData' which tries to populate the field and it does not work.

can any one please help?

this is a serious problem.

dummy1.zip

The script is working just the way you wrote it.

When a new record is created, the index2 field is blank. You don't set it to anything in your script, so there's no related record in dummy1 to pull from.

I also don't know why your Go to Layout script step is AFTER your New Record step or why you're sorting the records.