Delete field in table and automatically delete related fields queries

[oggstar1]

I am tidying up my database, and have some fields that I no longer require.

The problem is every time I delete a field in the table design format; I then have to go through and manually delete the same field referred to in all my 50 queries and reports. Otherwise, obviously the query or report does not work properly.

There must be a way that I can do this automatically delete all the related fields in a query after deleting a field from the table, as this would save me a lot of time.

Is there any way I can do this automatically?

Also is it possible to sort a table or query in design view by field name for easier reference?

Any help appreciated

 

[oggstar1]

Found this on teh web and makes no reference to deleting related database objects. Looks like it has to be deleted manually, unless anyone is aware of a handy tip.

When you delete a field, and if other database objects, such as queries, forms, contain references to the deleted field, you need to delete those references as well.

If a report includes a control bound to the deleted field, Microsoft Access won't be able to find the data from the field and will generate a message.

 

[Crowley16]

it's true, you have to manually delete the references in your queries and reports and forms...

--------------------
Procrastinate Now!