Copy Data between Portals script

Posted on 2011-10-27
Last Modified: 2012-05-12
I have a Tables Product ID , Production Day and Production Week.
In the Production week Table I have two Portals,
All Products to be Produced in Production Week are listed in this Portal
The next Portal   assigns a slected Product (which is listed via a value list showing the selected Items for the production week) to    A day or Days in the week of Production  .
This is fine except the if the list of products assigned for that week is lengthy it can be confusing.
What I would like to do is ,,,in the first Portal showing a list of products assigned to the week of production , I want to place buttons in each portal row next to the proiduct code Monday ,Tuesday,Wednesday,Thursday,Friday and Saturday.When the user decides that this Product must be produced on  say Monday it will create a new record in the Production Day Table and assigne that Product ID to the Monday of the Production week.The production week dates are based on Week Of Fiscal Year.
I need to know how to select one of the Product ID s  from the first Portal , Place it in  the Second Portal Product fieled , create a new record  and assign it to the correct day.You might need to know how the calendar is set up in order to answer the last part but right now what is important is to get the data into the second portal as a new record.
Many thanks
Question by:Krisraychris
    1 Comment
    LVL 12

    Accepted Solution

    Can that weeks items only be produced on a single day.  Or can the user select Monday and Tuesday?

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Conversion Steps for merging and consolidating separate Filemaker files The following is a step-by-step guide for the process of consolidating two or more FileMaker files (version 7 and later) into a single file with multiple tables. Sometimes th…
    Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now