>>>Thanks Bruce... you would think that the VIEW would have some internal connections to the mother TABLE, but I guess not...
>>
>>If it did automatically go to a base table's record, then what if you didn't want it to? That would cause trouble...
>
>I just thought if a VIEW is made from a TABLE then the VIEW should
>have some relatinship with the TABLE. Wheather you use the relatinship
>or not is up to you.
>
No, it's not automatic because a view is new entity, often composed of more than one table, or a subset of a table, etc. There is no easy mapping that will work in general...you can always store recno() in view if you really want to, I guess...
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.