Need Help to create database for students

[Inz]

Hello All,

I am not very good with excel. Need help to create database.

Is it possible that on student list sheet when i click students name it will show me information from students info sheet? If yes how can i possibly do that.

Also I would like create a form that will let me add new students on students list and also add all the info on the students info sheet?

I don't know why but i am unable to attach any file.
1.png

2.png


Please help!!!

[6StringJazzer]

The paper clip icon does not work for attachments. To attach a file:

1. Under the text box where you type your reply click the Go Advanced button.
2. On the next screen scroll down and under the Attachments section click the Manage Attachments link, which will show a pop-up window.
3. Click the Choose File button to select a file to attached.
4. Click the Upload button to upload the file.
5. Then click the Close This Window button. Your file is now attached to your post.

[torachan]

Adapted from one of my 'members clubs' forms.
To add an entry, first press 'Clear', add firstname and surname, boxes 3 & 4 will autofill after you have completed form and press 'Add'.
To 'Update' or 'Delete' first use top combobox dropdown to select.
If you have any queries about the code, post back on this site.