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

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