Moving Records from one Table to another in a single Database

[lmwright]

I could not find anything that actually answered how to copy data from one table to another in the same database. Do you simply import and while browsing, select the same database? I have not used Filemaker in a few years, so I am a little rusty.

I am basically trying to find a work around for the lack of conditional value lists in IWP. I have a huge list of inventory items, most of which are used rarely. For my main users, I have conditional lists based on a category that works just great. Now for the web users I am stuck. The list is crazy and long. I would like to actually duplicate a small number of items into seperate tables for each category. I was thinking of having a script find the top 25 items in each category for the last six months and load those into the category tables on a weekly basis. Then I could use portals or lists for them to choose from. They already have a place to enter items that are not on the list, for my approval. I figured I could built a script to check for duplicates at this point.

I am open to other options, but I have not found any so far.

[Fitch]

The import script step lets you specify both the source and the target table. Yes they can be in the same file. (Be aware that the source comes from the found set in the current window -- unless the source file is not open. When the source file is closed, all records in the source table are imported.)

Unfortunately, the import script step is not web-compatible. But I'm not clear if you're wanting to import within IWP or just to prepare your data outside of IWP.

[Søren Dyhr]

I am basically trying to find a work around for the lack of conditional value lists in IWP.

Other options exist, that doesn't jeopadize database integrity, by having duplicates floating around.

http://fmforums.com/forum/attachment.php?attid/11646/

--sd

[lmwright]

That will be very helpful in several places in my full file and I appreciate your great answer. Unfortunately, the conditional list is already in a portal record. I have attached a very reduced version of this file. I am trying to fix the page that enters requests so I can put it on IWP.

Thanks again!