Page 1 of 1

First Design Post

Posted: Sat Apr 20, 2002 3:44 pm
by abionifade
okay, here goes:

I got a a database which consists of a student table and an options table. Theory is that a student should be able to choose optional modules ( which are predefined in the options table ) during their academic year and thus have these modules assigned to them.

I have created another table called student options which will consist of the student name/ID along with the many options assigned to them (manually assigned entries via the web interface).

Im just racking my brains as to how to create a decent (intuitive), hassle free interface which will allow me to assign students these modules. My brain is dead from programming all day today and im wondering if you guys have any suggestions as to how i can lay this one out.


-Abi :roll:

Posted: Mon Apr 22, 2002 8:16 am
by Phirus
Can you give us more info...

May be able to put something together 4 ya

PhIrUs

Posted: Mon Apr 22, 2002 8:18 am
by Phirus
If you are worried about storing all of the options, what you could do Is explode the options into a string and store it in one field.

PhIrUs

Posted: Wed Apr 24, 2002 11:20 pm
by Ruiser
I've done something similar to this before.

I have a list of users who need access to certain items. I can add new items to an items table and users to a user table. I also have a UsersItems table.

On the first page, I have a list of all the users. Each user is a link to the next page that passes along the user id. then on that page I have a list of all the items along with checkboxes next to each one. you check off which check boxes you want this user to have access too, then click submit and it passes along the user id and all the checkbox values. the next page creates a record in the db for each item with the associated user id in the UsersItems.

You could also go in reverse and list all the items first, click one and it lists all the users who you want to have access to this item.

Hope that helps. I can post an example if you'd like to see it.

Posted: Sun Apr 28, 2002 6:19 am
by abionifade
Hi,

could you post your example?

I think what you have achieved is exactly what I am attempting to do.

Thanks Ruiser.

-Abi