Save as copy problem.

[Spidey]

I like to use "save as copy" a file and then delete the records that don't have a check mark.   How can I do it because right after I use save as copy the script cannot run anymore on the copy file.

 

Thanks.

 

KC 

[Lee Smith]

Why don’t you use the “clone no records” option? in the save as box, there is a tab that drops down>

[Spidey]

Thank you for your reply.  There are originally 300 and my client only wants to have 50 records when she use save as copy and she wants to keep the 300 records original file.   After I use the save as copy script it doesn't allow me to run the delete records script in the copy file.

 

Many thanks.

 

KC

[comment]

Can you explain the purpose of this exercise? It seems like a very peculiar request.

[Lee Smith]

Save as a Snapshot?

[Spidey]

The purpose of it is to save file size.  I would like to create a button that can delete the unwanted records.  This button will appear in both the original file and copy file.  Is there a way that my client can only use this button in the copy file and not the original file?  

 

Thank you so much for your replies.  I really appreciate.

 

KC

[comment]

The purpose of it is to save file size.

 

I am afraid that doesn't answer the question. Why is another file with a reduced set of records needed at all? If the records are marked (or identifiable in another way), the found set can be re-established at any time in the original file itself. If the purpose is to back up a subset of records, then you should export them, not save a copy of the file. The whole thing seems designed to create more problems than it solves.

 

 

 I would like to create a button that can delete the unwanted records.  This button will appear in both the original file and copy file.  Is there a way that my client can only use this button in the copy file and not the original file? 

 

With some difficulty, you could call the script in the copy from the original file. The difficulty lies in the need to define the yet non-existent file as an external data source. It also means that there can be only one such file at any time. Which brings us back to the question of purpose.

[Spidey]

I solved the problem by using global variable to define whether the ommited records could be delete.  Many thanks for all your replies.