Method:Classic General Q&A

Re: SalesRep table update issue

TogsTeam — Tue, 22 Nov 2011 00:51:03 GMT

Indeed, Michael - two years ago almost exactly to the day, I was wrestling with the same errors. I guess that suggests that one or both of us is consistent, at least.

Thanks for the pointer.

Re: SalesRep table update issue

Method_Michael — Mon, 21 Nov 2011 22:55:26 GMT

TogsTeam-

I think you had this same issue previously and it was resolved in THIS forum post.

-Michael

SalesRep table update issue

TogsTeam — Mon, 21 Nov 2011 22:25:32 GMT

In attempting to update my SalesRep table, I kept getting the message that I can't update the field that (RepID) that I'm trying to use as a key field. In trying various combinations, it appears that I managed to process an update without checking the "update records" option - as a consequence, I now have 2x the original records, and I'm getting errors b/c of duplicate RepID's and Initials.

I've downloaded and re-edited the SalesRep table so that it no longer contains multiple values, but now I can't get it to re-import... and frankly, I don't know if that will eliminate the duplicates or not.

Can you give me some help getting this cleaned up?

Thanks.