Ineresting , but better than enforcement will be understanding....

I see...You are right then, the documenter will not show you whether is a query or a table, may be this is the reason that seasoned developers add prefix "tbl"...

The documenter will give the record source of your reports...

If the Recod source is a query then you have to see the query definition that is pointing at.

I am curious...

What method are you using to transfer the data?

In what direction are you operating?

Who controls the transfer ?Access or Sql Server?

->>If you are running other applications on the same server, I will take a little caution...you never know what a SP has...

But if is the only application running on that...

I gess that you want to see what is the source of the report...

Goto the report, then under properties, find "Record Source" , it could be a table or a...

Hi GSquared,

Thank you very much for your comments, they are very valuable.

I have a better picture now.

Thank you guys!

Jorge

Thanks Michael,

I do not think that having them in place is a symptom of bad programming..., I am not saying that I am inclined to them either...

One of the points...

Thanks Michael,

What I was trying to say "Deleting by code" is handled by the application code.

Some one suggest that the records deleted by the cascade delete are not logged in...