Help with design

[teza2k06]

I am creating a database and currently have 3 tables which i will call on here Table 1, Table 2 and Table 3.
I have created the main look of my form which i want to be able to use with information from Table 1. I want to have have some Command buttons which i can set up so that i press for example F2 which will open a window or something with Data Fields from Table 2 so that i cant enter information and then press for example F7 which will save the information and F8 which will close that window.
Then i want a button which when i press for example F3 it will open up a different window or something with Data fields from Table 3 where i can also enter information in it then press F7 to save and F8 to close that window. and a F7 save button and F8 close button to save and close the main window which will be first thing you see when you open the form. (the above might sound confusing but i have a picture in my head of what i want the form to do etc, i just need to make it happen)
But all the information that is save on the windows i want all linked with each record, so that when i add a new record and when i press F2 or F3 then those windows will be blank and not have the information from another window, so that i can enter information and keep them saved in the tables and database.

And i also want a subform on my main page of my form but i have tried this and entered information into the subform but when i add a new record the information stays in the subform and does not go blank for the new record without me having to click the right button on the subform to add (hope this makes sense to)

Hope there are some people who can help and make it easier for me to do, i want to be able to get this plan i got in my head into action, but unfortunately im no expert with Microsoft Access

[orange]

I think these videos should be helpful.

Here are a number of free video tutorials related to database design concepts.

These free video tutorials describe the processes of data modelling, normalization and entity relationship diagramming. There are other videos, but this group is by the same presenter and covers an example situation.

http://www.youtube.com/watch?v=IiVq8M5DBkk Logical data modeling

http://www.youtube.com/watch?v=BGMwuOtRfqU Candidate key

http://www.youtube.com/watch?v=ZiB-BKCzS_I Normalization

http://www.youtube.com/watch?v=pJ47btpjAhA Normalization example

http://www.youtube.com/watch?v=q3Wg2fZENK0 1st Normal form

http://www.youtube.com/watch?v=vji0pfliHZI 2nd Normal form

http://www.youtube.com/watch?v=HH-QR7t-kMo 3rd Normal form

http://www.youtube.com/watch?v=q1GaaGHHAqM E_R Diagramming

http://www.youtube.com/watch?v=lXAGQ8vmhCY ERD Part 2

The first few topics at this site are well worth the read.

http://www.rogersaccesslibrary.com/forum/topic238.html

Good luck with your project.