Solved

How to populate the field from MS access in data grid

Posted on 2009-07-01
5
241 Views
Last Modified: 2013-12-25
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
0
Comment
Question by:rfedorov
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 39

Accepted Solution

by:
thenelson earned 250 total points
ID: 24759697
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
 
LVL 4

Expert Comment

by:Nicolaze
ID: 24762215
What is the structure of the Users Table?
0
 

Author Comment

by:rfedorov
ID: 24763822
id,Name, windows id
0
 
LVL 4

Assisted Solution

by:Nicolaze
Nicolaze earned 250 total points
ID: 24770029
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
 

Author Comment

by:rfedorov
ID: 24785471
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

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

740 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question