I have created an insurance database for my company. The trouble I have is figuring how to move data between two layouts. When I have a customer that cancels or dies I would like to check a box that would move that persons data from one layout to another so that they no longer show up on the "active client" list. Is there such a script?

Any help would be fantastic.

Thanks,

Jason

Edited January 23, 200718 yr by Guest

You could attach a script to the check box that does not have field entry enabled that runs something like this when clicked:

if(checkboxfield = "" [meaning empty])

{

set field "status" to "inactive client"

copy your record data to variables

go to layout x

create new record

paste variables

go to original layout

omit record

}

I have used this before. Let me know if you need any help with this.

Edited January 23, 200718 yr by Guest

Well, it depends, a layout is too general.

Do you want to transfer it to another table or just simply have it not appear on the list?

(2 layouts can be connected to the same table.)

I have attached a file with an example.

You would simply change any buttons that went to the inactive list layout to a script that first did a find on inactive and then went to the list layout.

Unless you want to completely move them to a separate table, which is the script I gave you earlier. let me know if you need any other help.

Feel free to ask. It took me a while to get the hang of FM too.

Enjoy.

Insurance.zip

Insurance.zip

That is awesome- thank you