Populate an FM Table Dynamically from SQL

[djlane]

I'm making an Invoicing front end in FM from an SQL data source.

The invoice line items table has a related table called Actions. Each line item has an action type, and there are about 30 different actions.

I need to add some extra fields on the action table, for grouping and sorting the line items on the invoice under different headings, but FM won't allow me to add fields (except calculation and summary fields), and I would prefer not to add the fields on the SQL table.

The field headings I need to sort / summarize on are not on the actions table (ie several actions need to be grouped under each heading), so I need to add them.

I want to create a new table in FM that is dynamically populated by the SQL table. In my new table I will add the fields for the Invoice summary headings and sort sequence.

In other words, my new FM table would be an image of the SQL table (changes in the SQL table would be reflected in the FM table), and I could add whatever fields I want to it.

Is this possible ?