Updating a Related Table

[Naia]

I have two databases, one containing the tables and one containing the forms and queries. The forms/query database is built from linked tables from the tables database. I would like to expand one of the fields from 7 characters to 9 characters. I planned on doing the in the table database, then updating the linked table. However, the table I need to alter has relationships with about 10 other tables and I get the (you cannot make changes to a related table error message). Is there a way I can make this change without deleting all the relationships?

For future reference, should the relationships have been created in the form/query database?

Thanks, N

 

[Dennisk]

No. delete the relationship, make your changes and reinstate your relationships.

 

[Naia]

In the future should I create relationships in the Forms/Queries database, the Tables database, or both are the same?

 

[Dennisk]

relationships must be set up the backend. when you link your tables the relationships are then set up as a view in the fe. ie you cannot setup referential integrity in an fe with linked tables.