A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Database Design Idea



 
 
Thread Tools Display Modes
  #21  
Old July 27th, 2009, 11:00 PM posted to microsoft.public.access.tablesdbdesign
John W. Vinson
external usenet poster
 
Posts: 18,261
Default Database Design Idea

On Mon, 27 Jul 2009 13:14:00 -0400, "Gina Whipp"
wrote:

John,

In one case I have no choice because the Client INSISTS they have the
ability to do! (I am refering to once Client in particular) and of course,
he pays when he *messes* the database up which is a routine with him bit
that is another story. Then there was the case where data that was brought
in form another source with matchind PK's to the existing data and I had to
run some update queries to change the PK's so I could get it into the table.
(I told them let's try not to do that again.

But other then that NO, NEVER, have you lost your mind... Okay I go
overboard. I just got in the habit of doing it that because of the above
scenarios. And since doing it that way never *hurt* anything I never
stopped. Of course in my latest adventure I set the PK as Autonumber and
gave them a *make-believe* PK because they wanted to edit it and I'm seeing
how that goes... The don't have a Purchase Order number until AFTER the PO
gets approved for ordering.


Sure, that's absolutely a good use of a "natural key". I do tend to put about
three rows of barbed wire and a deep ditch around any way to let users edit a
PK though.
--

John W. Vinson [MVP]
  #22  
Old July 28th, 2009, 12:15 AM posted to microsoft.public.access.tablesdbdesign
Gina Whipp
external usenet poster
 
Posts: 3,500
Default Database Design Idea

I here that!

FYI.. In another thread "Automatically insert foreign key into a table with
a one-to-", microsoft.public.access Kary Dewey also checks Cascade Updates.
He too seems to have gotten into the habit of checking it.
--
Gina Whipp


"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"John W. Vinson" wrote in message
...
On Mon, 27 Jul 2009 13:14:00 -0400, "Gina Whipp"

wrote:

John,

In one case I have no choice because the Client INSISTS they have the
ability to do! (I am refering to once Client in particular) and of
course,
he pays when he *messes* the database up which is a routine with him bit
that is another story. Then there was the case where data that was
brought
in form another source with matchind PK's to the existing data and I had
to
run some update queries to change the PK's so I could get it into the
table.
(I told them let's try not to do that again.

But other then that NO, NEVER, have you lost your mind... Okay I go
overboard. I just got in the habit of doing it that because of the above
scenarios. And since doing it that way never *hurt* anything I never
stopped. Of course in my latest adventure I set the PK as Autonumber and
gave them a *make-believe* PK because they wanted to edit it and I'm
seeing
how that goes... The don't have a Purchase Order number until AFTER the PO
gets approved for ordering.


Sure, that's absolutely a good use of a "natural key". I do tend to put
about
three rows of barbed wire and a deep ditch around any way to let users
edit a
PK though.
--

John W. Vinson [MVP]



  #23  
Old July 29th, 2009, 11:29 AM posted to microsoft.public.access.tablesdbdesign
andycambo via AccessMonster.com
external usenet poster
 
Posts: 5
Default Database Design Idea

I’ve decided to enhance database and included a time recording and billing
facility.

Here is how my database relationships are at the moment. I’ve done this one
in Access 2000 as it is available in work but I will be creating the real
database in 2007.

http://i630.photobucket.com/albums/u...p_database.jpg

My question is, will this work? The file creator table is so the user is
able to create a unique file number. But is connecting the Time Record and
Billing tables through this table a good idea?

Basically what I want to happen is, the Client Profile is created. Then user
then clicks a button and creates a unique file number (UFNID) which is then
used to create a new matter. The user is then able to Time Record the
activity of the matter such as time with client, preparing files etc (this
may be many records). Then once the matter has finished a specified user
will bill the file. The billing table will take all of the totals of the
Time Record (such as total of prep, total of attendances) and put together a
costs bill.

The billing table isn’t complete yet, this is just to see if I am on the
right track, but am I right? I am doing this right by linking the time
record table through the UFNID in the File Creator? Or should I be linking
it with something else?

Thanks
Andy.

--
Message posted via http://www.accessmonster.com

  #24  
Old July 29th, 2009, 02:02 PM posted to microsoft.public.access.tablesdbdesign
Gina Whipp
external usenet poster
 
Posts: 3,500
Default Database Design Idea

Andy,

Okay, it does look good except for two things...

tblTimeRecord
trFeeEarnerID - should be linked to tblFeeEarners which should be set up

tblFeeEarners
feFeeEarnerID (PK - Autonumber, change all FK's to Number [Long Integer]
and link on this)
feFirstName
feLastName
feCode

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"andycambo via AccessMonster.com" u53471@uwe wrote in message
news:99cb1b70763a4@uwe...
I've decided to enhance database and included a time recording and billing
facility.

Here is how my database relationships are at the moment. I've done this
one
in Access 2000 as it is available in work but I will be creating the real
database in 2007.

http://i630.photobucket.com/albums/u...p_database.jpg

My question is, will this work? The file creator table is so the user is
able to create a unique file number. But is connecting the Time Record
and
Billing tables through this table a good idea?

Basically what I want to happen is, the Client Profile is created. Then
user
then clicks a button and creates a unique file number (UFNID) which is
then
used to create a new matter. The user is then able to Time Record the
activity of the matter such as time with client, preparing files etc (this
may be many records). Then once the matter has finished a specified user
will bill the file. The billing table will take all of the totals of the
Time Record (such as total of prep, total of attendances) and put together
a
costs bill.

The billing table isn't complete yet, this is just to see if I am on the
right track, but am I right? I am doing this right by linking the time
record table through the UFNID in the File Creator? Or should I be
linking
it with something else?

Thanks
Andy.

--
Message posted via http://www.accessmonster.com



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 07:51 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.