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