How to populate the field from MS access in data grid

Let say, i have a table "USers"
I have a form "Desk back log:
this is layout:
name             code1            code2            code2
Peter             10                   3
Sandy           2          
Greg                                                           4
Total             12                    3                     4

i need to get the name field from table and bring to the Grid
Code1, code2 and so on should static titles
the user should be able to enter into the cells values and save in database
rfedorovAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

thenelsonCommented:
If you use that layout, you will create a lot of extra work for yourself because it is not normalized. this would be a normalized layout :

Person table:
PersonID   FName   LName    OtherFields...
1                Peter
2                Sandy
3                Greg

Users Table:
PersonID   Code    Value
1                  1           10
1                  2             3
2                  1             2
3                  2             4

About normalization:
Maximizing rows (records) and minimizing columns (fields) is the way databases are designed to work and is called table normalization.   To demonstrate this point, notice that Access and all other databases limit the number of columns (fields) but rows (records) are limited only by storage space.  These are the two tests that I apply for normalization:

1. Are there horizontal lists (columns, fields) that can be converted to vertical lists (rows, records).  If I do what will it gain me?  (Usually reduced storage, memory requirements, increased speed and the ability to work with the data easily) What will I lose? (Usually nothing)

2. If I have nn number of similar fields, is there a possibilty that I might later have nn+1 number of those fields?

A very common table design error is something like:
RecordID   Type1    Type2   Type3    ...
1                23
2                              77
3                 17                       7

Which should be designed as:
RecordID   Type   TheValve
1                1           23
2                2           77
3                1           17
3                3             7

Here is a great real world example of the importance of normalization:
http://www.experts-exchange.com/Databases/MS_Access/Q_21540867.html#14773468

A great turorial on Data Normalization
http://www.datamodel.org/NormalizationRules.html

Database normalization basics in Access
http://support.microsoft.com/kb/283878/EN-US/

Understanding Relational Database Design
http://support.microsoft.com/?scid=kb;EN-US;234208
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
NicolazeCommented:
What is the structure of the Users Table?
0
rfedorovAuthor Commented:
id,Name, windows id
0
NicolazeCommented:
ok so you take the Name from this table and display it in the grid, but in which table should the input in the grid be saved?
0
rfedorovAuthor Commented:
TO my understanding it should be something like editable grid
It should be  ability to add the number ( for Code1, Code2 ...) and save the whole record
Peter             10                   3  TodayDate

in the Results table
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic Classic

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.