Hidden Tables and Queries

[Amy Blankenship]

Hi, all;

I'd like to hide my tables in the main Tables window and just access them
from custom Groups to make it easier for other developers to find the tables
they need for a given type of data. However, when I do that, the tables are
not visible from the Queries interface.

I can make the hidden tables show in the Queries by showing hidden objects,
but that then makes the tables visible, albeit grayed out, in the Tables
window.

Is there any way to show tables in an organized fashion without hiding them
from the query builder?

Thanks;

Amy

 

[Amy Blankenship]

Is this the wrong forum to address this question to? If so, could someone
please direct me to the correct forum?

Thanks;

Amy

 

[Tim Ferguson]

Other "developers" should be well able to cope with a screen full of
tabledefs; if you have provided an alternative structure in custom groups
then sensible people should be able to take advantage of that too. I
don't see the point of trying to invisiblise the things in the normal
place to look.

If you have a big reason for trying to manipulate the UI like this, you
could remove all the tabledefs from the front end (you are using a split
structure, aren't you) and replacing all the queries with direct
connections as in

SELECT This, That, TheOther
FROM SomeTable IN [d:\etc\tables.mdb]

or whatever.

For users, it's normal to hide the entire database window and expose the
objects you want them to see in your own UI structure.

Is this the wrong forum to address this question to? If so, could
someone please direct me to the correct forum?

Well, it's not really a db design issue, but I'm not sure where else you
would go either.... possibly m.p.a.setupconfig but I don't really know
what goes on there.

Hope that helps


Tim F