Hi Listers, I've joined two tables using the GUID field.
My Table 1: Request_ID Table_1_GUID <- included as ***part*** of the join criteria ... My Table 2 Request_ID Table_2_GUID <- included as ***part*** of the join criteria ... Now I'd like to change the GUID on one side of the join to break a connection of one record and attach it to another. There seem to be no way to do it. I tried manually, by filter, by SQL. Each and every time I'm getting: ARERR [387] Updating this entry will violate join condition ARERR [302] Entry does not exist in database What am I missing? Is this achievable? Mark _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"