move record to a new table

[kibber]

I have almost no experience with the script maker so this may be more than I can handle.

I have my own work request database which I have made. There are (2) related tables:

'Current' - houses active work requests

'Storage' - houses completed work requests.

Currently the status field (you have a choice between active/completed/canceled) is a pop up menu.

What I ideally want:

when I change the status menu from active to completed (or canceled) I want the record to be removed from the 'current' table and placed in the 'storage' table.

I am not sure, but it might be helpful to have it happen after a time period say 24 hours or so after completion.

Anyone have any ideas?

Thank you for your help.

[aaa]

One of ways is to use import script from storage table. You must make changing record only one in found set, then perform import script from storage table, after delete record from Current table.

Edited September 21, 2005 by Guest

[kibber]

Thanks for the reply aaa

I think you are right on the money, only it is the actual script definition I am looking for. I am having a really hard time understanding the variables within the scripts.

Thanks again

[mr_vodka]

Why do you have this in 2 seperate tables when its just a status change? I am not sure that this is the best way to go about it.

[Inky Phil]

I am with Mr Vodka on this one. There may well be a good reason why you want to move the data to another table but think carefully about it.

Could you not achieve what you want by merely performing a find on status and working with the found set?

Phil

[kibber]

I have realized what I wanted to do sort of defeated the purpose of filemaker, but now I am having serious trouble fixing the problem.

So I bought filemaker work requests and it is an unbelievably complicated program...far too complicated for what I need so I have set about making my own.

I have made a layout where the information can be entered into a record. In that same layout I want a locked 'portal' under it displaying all the 'active' records from that layout. But if I can't do this because I can't reference the same layout in a portal. I like the 'table' view but I can't get my information entry screen if I do it that way. I have attached two jpegs to better demonstrate what I am trying to do.

Anyone have a solution?

Thanks for all your help.

[mr_vodka]

I am unable to get the file.

[kibber]

I guess it doesn't like .rar files

[mr_vodka]

Please check your email for my response