Synchronising table field name change in back end database to front end client

[STUFIX]

Hi,

I need to change a field name in a table stored on a backend database that is used by various queries, forms, etc on the front end client via a linked table.

I can't work out how to change the name in the b/e without having to change all the individual references to it in the f/e.

I haveauto name correct turned on in both f/e and b/e but I guess these are not related to each other.

Any suggestions please?

Rgds
Stuart

[Stewart Ross]

Hi,

I need to change a field name in a table stored on a backend database that is used by various queries, forms, etc on the front end client via a linked table.

I can't work out how to change the name in the b/e without having to change all the individual references to it in the f/e.

I haveauto name correct turned on in both f/e and b/e but I guess these are not related to each other.

Any suggestions please?

Rgds
Stuart

Hi Stuart. You could use the Object Dependencies facilities to track down all objects which have a dependency on the linked table, then change all references to the old field name manually.

Since this is likely to be time-consuming and error-prone, do you really have to change the field name? You could always add a copy of the field to a query based on that linked table and alias that field in whatever way you want, then base whatever you need to feed with the new name on the aliased field. This would protect the integrity of all existing queries, forms etc in your current application.

If you really do want to change the field reference manually throughout right-click on the table and select Object Dependencies from the shortform menu. This will run for a short time and show you all queries, forms and reports that have a dependency on your linked table. You would then have to open these one by one, check their fields, and change the references yourself.

-Stewart