John-

PMFJI-

>B. .If I remove an address by issuing a DELETE and a TABLEUPDATE(0,.T.) it removes itself from the grid; If I then re-add the same SHIPTOCODE for that Customer, I get a "Unique violation" error...this probably has something to do with my "Primary Index Key"...why do I get this? I just previously deleted it? It is actually unique.

Since deleting a record doesn't actually *remove* the record, it is _not_ unique. What you would do is put a .NOT.DELETED() filter on your primary key, and make sure you add an index on DELETED() also, so that Rushmore optimization can be used on the primary key.


>I apologize for this lenghtly reply, but I am failry new to VFP....It is the first time I am using Local Views. I find them pretty frustrating.

That was my experience, too, when I committed to implementing local views. I was very frustrated. However, it is well worth the pain. I can't stress that enough. I wouldn't go back now at all, and I really hated local views at first. :-)