AnsweredAssumed Answered

identify active portal row??

Question asked by AndrewFish on Aug 23, 2010
Latest reply on Aug 23, 2010 by RandyS_1


identify active portal row??


I should first point out that I'm very new at this (4 months)

I am developing a DB for a dance school that will manage class roles & invoicing.

the tables and relationships involved look something like this:

Customer - Student (1 to many)

Customer - Invoice (1 to many)

Student - Class (many to many)

I am wanting to write a script that will copy data from a portal on the Class layout across to a related invoice associated with the customer. I am having trouble writing a script that 1) Identifies the active portal row to copy info from and 2) finds the related customer invoice to paste the info.

any help would be appreciated