General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>If you have a updateable view based on two tables (or n tables), is there any way to tell/force the order in which the tables are updated?
>
>I don't think so. If this is an issue, why not break the information into two or more views and cycle through them in the order you require.
Thanks Larry
That is probably the best way. I was trying to see if I could aviod that. My underlying data structure changed and normalizing forced the spliting up of several tables. If I use two views where I previously use one, I have to (find and) add an additional TABLEUPDATE for each view and have to change the ControlSource of about half the controls on my forms. Pain in the butt but probably no way around it.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only