Many sub datasheets??????? (1 Viewer)

[smelly]

Can a datasheet from a table have many sub datasheets? I have a project number that can have up to thirty tests performed on it and I would like to show all the tests listed under the project number as a sub datasheet. I was thinking a query might be better but I wouldn't know how to do this with 30 tables and also each table has up to 20 entries. Does anyone have an idea of how to display this nicely in one view such as a sub datasheet view?
Thanks again!!!!!!!

 

[sambo]

You need to Normalize your table structure.

--tblProjet--
ProjectID (Primary Key: Autonumber)
ProjectName (Text Field Displaying Project Name)

--tblTest--
TestID (Primary Key: Autonumber)
ProjectID (Foreign Key From tblProject: Number)
TestName (Text Field Displaying Test Name)

--tblQuestions--
QuestionID (Primary Key: Autonumber)
TestID (Foreign Key From tblTest: Number)
Question (Text Field Displaying the question relating to current test Record)


View the latter half of this post for more details about Normalization.