>I have a curious question. I am creating a view based off of four tables, only one of which I would actually like to update. The other three simply provide some fields that are displayed for the user. However, when I create the view in a program file rather than the view designer, the fields used to link the primary table to the three lookup tables cannot be updated. The solution is to go into the view designer and set the Update Table property to the name of the primary table. I have tried doing this using DBSETPROP('ViewName', 'VIEW', 'Tables', 'mydb!mytable') but it doesn't seem to have any effect. I have included the code I use to create the table. If anyone has any suggestions, please let me know.
>
What does TABLEUPDATE() return?
Do the rest of the fields get updated?
Erik Moore
Clientelligence