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