Should I Have Only 1 Table?
- From: JD McLeod <JDMcLeod@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 27 Jun 2005 22:05:02 -0700
I am creating a database which will list various internal control processes
for the various business cycles. There will only be about 7-10 cycles, but
each cycle can have multiple controls, some as few as 10 while others can
have as many as 75 to 100. All of the forms, reports, etc. will be similar
in their structure, the only difference being which cycle. At first, I was
going to have a separate table for each cycle, but then I thought it would be
much simplier to have one table and a way to identify the various cycles.
Our current filing system is to use a letter to represent the cycle (B for
the treasury cycle) and a number for each control. B1, B2 etc. Here is
where I am stuck...
I have a form for the user to enter new control processes into the database.
The user selects the cycle name and it stores the cycle letter. The next
field is the control number which I currently have set to an autonumber. As
long as you are entering controls for the same cycle, the autonumber works
fine, but once you select a different cycle letter, the autonumber doesn't
start over, but rather keeps going. For example, if you enter the three
controls for treasury you have B1, B2, B3 and then you enter your first loan
control you get E4 rather than E1. If I have a separate table for each cycle
this isn't a problem, but I don't know if that makes sense since the data is
similar in every other respect except for which cycle it belongs to. Is
there a way to have the autonumber start over when a new cycle is detected?
Should I change the structure of my database? I want to be sure I get this
project started off right so any advice is much appreciated.
.
- Follow-Ups:
- Re: Should I Have Only 1 Table?
- From: Jeff Boyce
- Re: Should I Have Only 1 Table?
- Prev by Date: Re: How to Add a Field with Alert Table sentence?
- Next by Date: Re: Specifying path to linked tables
- Previous by thread: How to Add a Field with Alert Table sentence?
- Next by thread: Re: Should I Have Only 1 Table?
- Index(es):
Relevant Pages
|
