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. |
|
|
Thread Tools | Display Modes |
#21
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|