Script for "automated" data entry using portal
Need some help writing a script that "automatically" enters data for me. Ive got some of it written, but cannot get the desired result.
The process I'm trying to create:
Step 1: "Maunally" Enter Data in "Portal Test"
Project ID(PK) TeacherName TaName
Step 2: "Manually" Enter data in "Proposed"
Project ID(FK) Class Name StartDate Finish Date
HE001 English Lvl1 01Jan2012 04Jan2012
HE001 English Lvl2 01Jan 2012 04Jan 2012
Step 3: Run script to automatically fill in "Actual" so it will end up looking like this.
ProjectID (FK) Class Name Teacher Name Date
HE001 English Lvl1 John 01Jan2012
HE001 English Lvl1 John 02Jan2012
HE001 English Lvl1 John 03Jan2012
HE001 English Lvl1 John 04Jan2012
HE001 English Lvl2 John 01Jan2012
HE001 English Lvl2 John 02Jan2012
HE001 English Lvl2 John 03Jan2012
HE001 English Lvl2 John 04Jan2012
ON the "Portal Test" Layout, I have setup a portal to "Proposed" (so I can enter them all in one go).
Relationships are setup so the ProjectID is automatically filled in.
Seems taht whatever I try to do, the script only knows to enter the "English Lvl1" and not for "English Lvl2".
I'm pretty sure I have multile problems (Design problem? Wrong script logic? Wrong script usage?) Anywa any help would be greatful. Thanks!