Emilia,

Sorry for the late response. My motherboard failed on me. The
troubleshooting process took a greater portion of last week. Hardware
issues are not always easy to verify. The situation still has me
irate.
>Run-time error '3331':
Error Description: To make changes to this field, first save the
record
>Is the AddrID by any chance the primary key, or some other unique
>value? If so, you cannot duplicate it of course.
Yes, AddrID is the primary index and the database cannot duplicate it.
The objective relates to changing the relationship structure; in other
words changing the AddrID in the relation to CompID. Here's a
reiteration of the relationship table.

TABLE
trelCompAddr

FIELDS
CompID
AddrID
Addr2
AddrTypeID
Phone
Phone2
Fax2
Email
> I don't know what error 3331 is, but if the address table is the
> many-side of a 1-to-many relationship, you would also need the value
> of the company ID as the foreign key.
Error 3331 is not clear to me either. Let me know if you have found a
site with error descriptions. My initial internet research could not
locate such a site. Yes, the address table is on the many side, yet
CompID is on the many side since Companies have more than one
location.

>
>
>