>>So why not a view?
>
>Certain users have the ability to change data in the tables directly in the grid. I was told that views would be complicated for this because you are not actually changing the values in the table and have to make function calls to update the table itself.
No - views are not complicated and, as I understand you, are ideal for this.
So, in the View designer, on the "Update Criteria" tab, you check "Send SQL Updates" and check, under the pencil column, all the fields that you want to allow the user to be able to change.
Thus your view becomes like an updatable single table.
HTH
Terry
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.