How can I find where table fields are used in the front end?

[gellerche]

I'm doing normalization on an application that was given to me. The original designer has combo boxes (ie. multiple values) in some of the fields in the tables, and I want to change those to single values. The original designer said his reasoning was so his forms could have drop downs directly from the tables. Changing them is not a problem.

What I would like is to find every place on the forms that uses one of these fields. Is there a utility in Access that matches up the fields in the tables to every form they're used in so I have a list of the forms?

Thank you,

Steve Geller

 

[WayneRyan]

Steve,

ORACLE forms can do this quite easily.

In Access though, if ALL of the forms were based on queries
then you could traverse the mSysObjects table, grab all of
the queries and look for the ones that referenced your
field.

There are some shareware products that do "backups" and
store text versions of Access objects. That might be a
resource.

Wayne

 

[gellerche]

Wayne:

Just to clarify, are you saying that table fields in an Oracle database can hold multiple values? The reason I'm asking is that this seems like such a bad idea. I mean, it seems to me that every field in every record should only have one value (different values from field to field and record to record, but any particular field should only have one value).

 

[WayneRyan]

No,

When you develop in ORACLE Forms, it stores info in its own
collection of seperate tables. You can see what forms that
you have in your app, what tables they reference, what fields
they reference, and all of the events (triggers) in use.

Access does not do this, but mSysObjects does store your
queries. If you based ALL of your forms on queries, then that
is where your answer would be.

Wayne