Create a grid for info entry using other fields

[Bretto99]

Been battling this for ages and must be missing something simple! A user enters a list of items in one table eg Names of students. In another table a list of subjects which are available to the students is entered.

Is there any way to create a new form/table/datasheet where the Subjects list is put along the top, the Names are down the side, and then let the user fill in a %mark and a symbol (ie two pieces of data) for each person in the list, the inputted info which gets stored in another table (or even in one of the two existing tables). I dont want to specify the subjects or names during design as they will change from year to year.
Many thanks.

 

[Darrylles]

The only difficult thing here is deciphering your problem - what is it?

You can create a new form - no prob.
You can create a new data-sheet - no prob.
You can create a new table - no prob.

Which do you wish to create - mate.

Or do you want us to do all of the work for you?

"Never argue with an idiot, he'll bring you down to his level - then beat you with experience."

 

[Bretto99]

Darryl, not looking for anyone to do the work for me - just a bit stuck. You can see what I want to do at:

http://www.users.bigpond.com/captpipers/example.htm

I KNOW it is probably simple and would not have posted here if I could have worked out how to do it.

Thanks again for any input.