Editable pivot tables

A

Andrew van Zyl

Hi Folks
I want users to be able to edit a FP Active-X pivot table
and write the edited data back to the SQL Database.

It works fine when the pivot table is linked to only one
table.

I can't seem to get the edit function to work when using
two or more tables in a join. Ive tried pointing to a
view, and also putting the T-SQL command in the setup of
the pivot table.

All underlying tables have Primary Keys etc.

This seems to defeat the purpose of using a relational
database.

Any suggestions?
 
Top