Do you know how to define a summary field?
A summary field can be defined to total the values stored across all the records in your current found set in a specified field.
I understand that. I do not want the summary for the found set. I want the summary for all records
Please define "All Records"... (there are also ways to set up a relationship with aggregate functions that compute totals.)
"I also want to calculate a total for all loans for the officer (current and past due) so I can calculate the total portfolio for the loan officer and compute the % of past dues for the officer to their total portfolio."
That appears to describe a specific subset of the total records in your table and using a find to pull up a found set is one way to do this. A relationship may be another.
Here is another way of stating what I need help with. Trying to figure out the equivalent of a Make Table in Access. I have a summary report that has totals for each loan officer and amount of loans. I want to write each record in this summary report to a file. What do I need to do to write each sub summary line to a previously defined table?
Make table isn't really an option in Filemaker. (I've developed in Access also, so I understand the SQL you are referring to.)
It's usually a more flexible approach to keep all your data in the table where it is and manipulate groups of records by performing finds or working with relationships.
You can use import records to move data from one table to another.
Why do you need to move this data into another table? (Perhaps I can suggest an approach that elimnates the need for a separate table.)