Hello,
This is my first post, i couldn't find an answer to my problem over
the other posts.
first - I have a Main table called [tblFile], this table has a primary
key that is an autonumber.
second - I have a LOT of tables that uses tblFile.ID as a foreign key.
thrid : I'm trying to see if i can do a query or a function (in VBA)
that could let me know Which other tables uses tblFile.ID in at least
1 row.
problem : there's too much related table to hardcode this function
example : the table tblProperies uses tblFile.ID as a foreign key and
the table tblProgram Also uses it as a foreign key. Actually there's
3 rows in property that uses a specified ID from tblFile and no rows
from tblProgram uses it.
So actually I want my query/function to return : "tblProperties" only.
Actually i don't know anything about this concern so please somebody
give me a hand!