Relationship Issues

[Guest]

Hi,

I am trying to creat a query where one side of the relationship is to be
changed from Mid GC to GC. When I create the new relationship I cannot delete
the old relationship. There are others who are using the table. Do I need to
get them out or is there something else going on here?

 

[Guest]

If Mid GC & GC are the many side then why not just create a second
relationship?.