my database building

Hya, I this one seems to defy all experts I have consulted, here on the web and in our team. What I need is to be able to access subindex tables fom an index file, and the answers tables from the subindex tables. everything has to be able to be visualized starting from the index file, but at every level, many tables must be linked to a single table. So if you have any pearls of wisdom...

Maybe it's cos it's 1am here, but I have no idea what you are talking about. :P Can you elaborate, and a bit more clearly?

It sounds like your talking about a normal relational database setup? Primary Keys, Foreign keys, etc?

er...
I want to be able to review the data in a coherent way in my database: to be able to see a list of the subjects from the Index table, pick a subject and see a list of the subject indexes, then pick a subject index and see a list of answers data. This has to be done without forms or reports to start.
hope this helps...

Note that a database is simply a place to store data. You cannot "interact" with it, only perform queries. Once you've got your DB setup, you then need to create an interface for it, using a programming language.

To achieve what you want is quite simple, and can be done in one of two ways:

i. Using two seperate tables, one for Subjects, and one for Answers.

ii. The other is to create a single table, using a heirarchical setup. That is, by having an itemID, and a parentID as fields (plus whatever else you need).

HTH,
stumpy