Moving Records

[ianmuir]

Hi, I have 2 layouts "Leads" and "Prospects" which both have their own tables.

I have made a script that imports a complete record from Leads into Prospects then

deletes the record from Leads after it has been moved.

This works well.

The problem is after the export and deletion the Leads are reset and back to record No1

I need it to go back to where it was even if i was in a Find.

Any Ideas?

Ian

[bcooney]

If you open a new window first, then import/delete, then close window, you'll definitely preserve the found set, but I'm not sure which record will be active (since you just deleted the former active record).

Must tell you that a better approach is to have one table of People with a type. In fact, the type should be a TypeID and reference the PeopleType table.

[ianmuir]

Hi, that does not seem to work.

[ianmuir]

Hi, heres the script

Set Error Capture [on]

Show all records

Omit record

Show omitted only

New window [Name:CE]

got to layout ["CE Prospects (CE Prospects)]

import records [No Dialog; "Carbon.fp7"; Add; Windows ANSI]

Close Window [Name:"Ce"; Current File]

The new window opens ok and the data is imported accross. The orginal window loses all finds and is set to 1 record and you have to press "show all"

any ideas where I have gone wrong?

Ian

[bcooney]

The New Window step should be after Set Error Capture on.

Again, you really shouldn't have two tables. See, This thread.