Database Design Idea

[John W. Vinson]

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.

 

[Gina Whipp]

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

 

[andycambo via AccessMonster.com]

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/uu29/andycambo/relationship_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.

 

[Gina Whipp]

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