I have a number of tables which have a text field of the same name. It is 
used to hold a record reference number and links the tables together in 
queries. Currently it is 15 characters long but I want to increase it to 20. 
If I try and do it in table design I get a message that says it is used to 
link tables in a relationship and I must delete the relationship first. Is 
there anyway I can do this rather than opening dozens of queries, deleting 
the relationship, change the field size then open all the queries again to 
re-create the relationship? I tried opening the Relationship window but 
there aren't any shown there as I only create the relationship at the query.
Thanks
Tony 

Are you sure there are no relationships? Make sure you click on Show All 
under the Relationship window.

Joins you've created only in queries will not cause that message to be 
generated.

Have you perhaps used the field as a Lookup field?

-- 
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Tony Williams" <tw@invalid.com> wrote in message 
news:e1rIumx3HHA.1484@TK2MSFTNGP06.phx.gbl...
>I have a number of tables which have a text field of the same name. It is 
>used to hold a record reference number and links the tables together in 
>queries. Currently it is 15 characters long but I want to increase it to 
>20. If I try and do it in table design I get a message that says it is used 
>to link tables in a relationship and I must delete the relationship first. 
>Is there anyway I can do this rather than opening dozens of queries, 
>deleting the relationship, change the field size then open all the queries 
>again to re-create the relationship? I tried opening the Relationship 
>window but there aren't any shown there as I only create the relationship 
>at the query.
> Thanks
> Tony
> 

Thanks Douglas clicked on Show all and they appeared.
Thanks again.
Tony
"Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message 
news:eJQsYwy3HHA.4712@TK2MSFTNGP04.phx.gbl...
> Are you sure there are no relationships? Make sure you click on Show All 
> under the Relationship window.
>
> Joins you've created only in queries will not cause that message to be 
> generated.
>
> Have you perhaps used the field as a Lookup field?
>
> -- 
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
>
> "Tony Williams" <tw@invalid.com> wrote in message 
> news:e1rIumx3HHA.1484@TK2MSFTNGP06.phx.gbl...
>>I have a number of tables which have a text field of the same name. It is 
>>used to hold a record reference number and links the tables together in 
>>queries. Currently it is 15 characters long but I want to increase it to 
>>20. If I try and do it in table design I get a message that says it is 
>>used to link tables in a relationship and I must delete the relationship 
>>first. Is there anyway I can do this rather than opening dozens of 
>>queries, deleting the relationship, change the field size then open all 
>>the queries again to re-create the relationship? I tried opening the 
>>Relationship window but there aren't any shown there as I only create the 
>>relationship at the query.
>> Thanks
>> Tony
>>
>
>