By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,500 Members | 830 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,500 IT Pros & Developers. It's quick & easy.

Table relationships

P: n/a
Hi All,

I am working on a database which has over 30 tables and they have
relationships between them. Sometimes I notice that in the forms I get the
information which I don't need. For example, I get CityID instead of
CityName. I can easily find out what table contains CityID displayed in my
form, but I don't know how to find if there is a table which has CityID and
CityName. If I can find, I then can show the CityName in the form, instead
of CityID.
I don't know if such a table to contain CityName even exist. Maybe there is
a way to show all the tables which have CityID as a field in them? If I can
see them, at least I can go only through those ones, instead of all the
tables.
I think it can be done with some VBA code, using the TableDefs. But maybe
there are better ways of doing it

Any help appreciated.

Regards,
Nicolae


Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
in access97, goto tools -> analyze -> documenter
select the 'tables' tab
click 'select all'
click the 'options' button and select relationships & 'name, data types and
size'
save the resulting report as a word document and search at will
"Nicolae Fieraru" <no****@please.cxm> wrote in message news:<40********@duster.adelaide.on.net>...
Hi All,

I am working on a database which has over 30 tables and they have
relationships between them. Sometimes I notice that in the forms I get the
information which I don't need. For example, I get CityID instead of
CityName. I can easily find out what table contains CityID displayed in my
form, but I don't know how to find if there is a table which has CityID and
CityName. If I can find, I then can show the CityName in the form, instead
of CityID.
I don't know if such a table to contain CityName even exist. Maybe there is
a way to show all the tables which have CityID as a field in them? If I can
see them, at least I can go only through those ones, instead of all the
tables.
I think it can be done with some VBA code, using the TableDefs. But maybe
there are better ways of doing it

Any help appreciated.

Regards,
Nicolae

Nov 13 '05 #2

P: n/a
Hi Roger, thank you very much. I will do that
Nov 13 '05 #3

P: n/a
rkc

"Nicolae Fieraru" <no****@please.cxm> wrote in message
news:40********@duster.adelaide.on.net...
Hi All,

I am working on a database which has over 30 tables and they have
relationships between them. Sometimes I notice that in the forms I get the
information which I don't need. For example, I get CityID instead of
CityName. I can easily find out what table contains CityID displayed in my
form, but I don't know how to find if there is a table which has CityID and CityName. If I can find, I then can show the CityName in the form, instead
of CityID.
I don't know if such a table to contain CityName even exist. Maybe there is a way to show all the tables which have CityID as a field in them? If I can see them, at least I can go only through those ones, instead of all the
tables.
I think it can be done with some VBA code, using the TableDefs. But maybe
there are better ways of doing it


Paste the following into the SQL view of the Query Builder:

SELECT MSysRelationships.szObject &" ("
& MSysRelationships.szColumn & ") <---> "
& MSysRelationships.szReferencedObject
& "("& MSysRelationships.szReferencedColumn&")" as relationships
FROM MSysRelationships
ORDER BY MSysRelationships.szObject;


Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.