Tables and Forms

[Urban Planning Major]

I have a big database that I am cleaning up and will eventually add a
switchboard too. Nevertheless how can I tell if every form has a table
associated to it? To identify the tables that doesn’t have forms.
Thank you

 

[Jerry Whittle]

For forms you could open up each one and see what bombs out. Tables and
queries are a little more difficult.

Rich Fisher's excellent Find and Replace add-in might be just the ticket. If
you register it (one of the best $37 I've ever spent), the cross-reference
report can find what tables and queries use which reports and forms. It's a
good way to find orphans.

http://www.rickworld.com/

 

[Klatuu]

I was going to recommend the same Find and Replace Jerry already did, but one
other thing I would like to suggest. Rather than using the Switchboard,
create your own form and use that instead.

Switchboards are too constraining and have some issues. One being that when
you are doing a Find and Replace using Rick Fisher's tool, it does not find
values in the Switchboard.

 

[Amy Blankenship]

You shouldn't have a form for every table. With a properly normalized
structure, often you will be entering data into several tables with one
form.