Reading from a System Table using as a template
OK, I have a simple system table that has an expense desc, hourly rate and flat rate, called Expenses.
I created a layout with a portal that allows you to choose from the system table Expenses into an account level table called Event_Expenses. That all works fine. Now I want to extract the hourly rate and flat rate from the Expenses system table and initialize the Event_Expenses with their values.
What's the best way to go about doing this? Is there good documentation somewhere on how to use related tables and their values?