View records without portal?

[darrel]

Hello,

I have a database that is used for entering student results for various types of assessments/tests.

There is one table with student data and 5 different tables with student assessment data.

What I was hoping to do was show all results from the various assessment tables in the one layout.

I want to know if this possible without using portals because I have no way of knowing how many of each type of assessment teachers will use.

The student table has a key Stud_ID to the various assessment Tables. I need to pull out the results from each assessment table and put them on one layout (without portals) Is this possible?

Thanks

Darrel

[Søren Dyhr]

There is one table with student data and 5 different tables with student assessment data.

These five tables needs to get merged into one, and the majority of display issues disappears. The test/assesment type should be an attribute to distinguise them from other similar.

--sd