473,323 Members | 1,622 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,323 software developers and data experts.

How to break up table?

83
I have a table with about 80 fields and 400 lines. I separated the tables into a database that sits on a server and all people have a copy of the access program with forms, tables, and reports on their desktop. The remote access connects to the server, it's pretty simple.
I want to improve speed.
So far, I have included onload events in a form that define the record source and set for the main source and combo boxes. I also clear them on exit. Both of these improved speed. The most common form uses about 30 fields and the other form uses about 30. Some fields overlap.
As a separate issue, but which I think is related:
Lets say there are 5 clients and each client has 6 fields that are associated with it. Every line of the database therefore has 30 fields that are associated with the 5 clients. Not every line will have all client fields filled out, actually on a form, there is a program that I wrote that determines which clients will be used for each line. The problem arises when I want to create a report by clients. So far, I have one query that selects a line if any one of the clients has one field filled out(the field is the first in the sequence of the 6). Then I create separate reports that filter for each client, then I create one report with all the subreports because otherwise, I would have to include a report with 30 variables.
Is this the most efficient way, if not, will breaking up the tables help this situation. Thanks
May 22 '07 #1
2 2258
jl2886
83
Does anyone have any advice?
May 23 '07 #2
MMcCarthy
14,534 Expert Mod 8TB
I have a table with about 80 fields and 400 lines. I separated the tables into a database that sits on a server and all people have a copy of the access program with forms, tables, and reports on their desktop. The remote access connects to the server, it's pretty simple.
I want to improve speed.
So far, I have included onload events in a form that define the record source and set for the main source and combo boxes. I also clear them on exit. Both of these improved speed. The most common form uses about 30 fields and the other form uses about 30. Some fields overlap.
As a separate issue, but which I think is related:
Lets say there are 5 clients and each client has 6 fields that are associated with it. Every line of the database therefore has 30 fields that are associated with the 5 clients. Not every line will have all client fields filled out, actually on a form, there is a program that I wrote that determines which clients will be used for each line. The problem arises when I want to create a report by clients. So far, I have one query that selects a line if any one of the clients has one field filled out(the field is the first in the sequence of the 6). Then I create separate reports that filter for each client, then I create one report with all the subreports because otherwise, I would have to include a report with 30 variables.
Is this the most efficient way, if not, will breaking up the tables help this situation. Thanks
Have a look at the following tutorial.

Database Normalisation and Table structures

Remeber you can break up tables in a one to one relationship.
May 25 '07 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: Anshul Seth | last post by:
I have been dealing with the page-break problem for long, and have not been able to come to a solution. I am using XSL:FO to generate PDF report for my XML, generating it in tables. I want that...
0
by: Rary | last post by:
I am using XSL:FO to generate PDF report for my XML, generating it in tables, i want that tables should completely be at one place, if there is a page break , all the contents of the table should...
1
by: Michael A. Drawbaugh | last post by:
We have several webforms that represent Online Reports. When printed, we would like to be able to control the pagination based upon a line count. We have been trying to use the PAGE-BREAK-AFTER...
6
by: mark | last post by:
im trying to split prints out by using <STYLE>P { PAGE-BREAK-AFTER: always }</STYLE> in the <HEAD> </HEAD> section however its not page breaking like i would like - i want it to page break...
7
by: Abraham Luna | last post by:
how do i stop the dynamic validators from breaking explorer if i use a dynamic validator and move to a different control it breaks explorer and i can type in the page when i'm not supposed to....
8
by: CJM | last post by:
What is the best way to force a page break when printing from a browser? A page in my application generates a series of tables which are usually less than will fit on a page of A4. Ideally I want...
16
by: matt | last post by:
hello, ive been trying to figure something out, largely thru trial & error. thought perhaps someone else may have knowledge. i have an html table that consists of blocks of related data --...
1
by: =?Utf-8?B?U3VyeWEgUHJhYmhh?= | last post by:
I am using <div style =page-break-before:always</divfor page break while printing a layout designed using <table>, <tr>, <td>. It is working fine in IE 6.0. But this is not working properly in...
7
by: =?Utf-8?B?aXdlYg==?= | last post by:
Can we set page breaks in ASP Pages dynamically based on the data being populated? Akshay.
0
by: krokador | last post by:
I've been looking over the net and there doesn't seem to be any other people around who's had that problem (or my googling skills are off this morning) so here I am asking this question: I have an...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.