GTRR and New Record Creation honoring Lookup function

[Rich K.]

Hello all --

I have a list of records (from TO1) in a found set (lets call FS1) and it has a date range specified. I want to loop thru FS1 and create a record for each day for each record in FS1 to a related TableOccurrence (lets call TO2). I have Lookup() functions dragging a majority of the fields from TO1 to TO2.

If I did this on screen I have a hidden layout that I transfer FS1 to ... and this hidden layout has a portal to TO2 that will allow me to add a record and all the Lookups will fire populating 95% of the new TO2 record.

I created the script based on the the above paragraph (and it doesn't seem to want to play nice).

However, I don't even know if this best way to do this ... prolly not.

Can anybody point me in the right direction?

Regards,

Rich

Edited August 28, 2009 by Guest

[comment]

Can you explain what are you actually trying to achieve here? At first glance it seems like a needless replication of data.