Is using a combination of local and sql tables a typical method of doing things? I had thought of that, but guessed a true sql program only used sql tables. Do transactions lock the whole table or just the record being added/worked on?

- Gary