John Clark
John.Clark at niagaracounty.com
Wed Aug 24 13:50:23 CDT 2005
Well, I don't know if they so much need a "default" role. I've got to enter the name in at some point, and I guess at that time they could get their initial designation...maybe even automatically, dependant on where I call it from. Since writing my initial "cry for help," I've been experimenting with a "names" table (close to a person table Drew) that has the fields I mentioned. I then made a query for each logical field, which I would probably make a single sql statement for if I go this way, to test it out. It works pretty well and gives me proper results. Now I've just got to experiment w/getting data in...believe it or not I don't use recordsets very much and I think that is what I'll need to do here. I've gotta leave here soon for the night and take my kids to music lessons, but I'll be hitting it again tomorrow AM. >>> DElam at jenkens.com 8/24/2005 2:20 PM >>> Hmm, to get a smaller list you may need to have a field in person with their "default" role. As long as you allow for getting a larger list, this could work nicely. Debbie -----Original Message----- From: John Clark [mailto:John.Clark at niagaracounty.com] Sent: Wednesday, August 24, 2005 1:13 PM To: accessd at databaseadvisors.com Subject: RE: [AccessD] Logic issue It isn't really based on trials though. It is based on indictment numbers, and these may or may not go to court...a defendant could plea out before it hits trial, or charges could be dropped. I think we are on the same page though, except it seems like you would pull all from this table, which I would too, but I want to filter it for certain lists (i.e. I don't want a thousand names showing up when I want to basically choose from three judges). I don't mind including all names when adding defendants, because it is probably necessary. >>> DElam at jenkens.com 8/24/2005 1:47 PM >>> I would actually have a table of people that includes everyone. Second, a table of trials. Link those two with a third table that has the trialID, personID and an ID indicating what role they had in the trial. Given the cross connections and likely possibility of multiple people in one role for a trial, this is the only scalable solution. Debbie -----Original Message----- From: John Clark [mailto:John.Clark at niagaracounty.com] Sent: Wednesday, August 24, 2005 12:36 PM To: accessd at databaseadvisors.com Subject: [AccessD] Logic issue Hi all I am having trouble working out how I want to go about something, and I am hoping somebody here can give me a nudge. It doesn't sound difficult, but I'm running into dead-ends. I am starting to think that I will just have to go ahead and finish up with "whatever" and work around things. I am doing a project for a district attorney's office, and it will basically just keep tabs on everybody that passes through the system. The problem is though that there are "Defendants", defense lawyers, prosecuting lawyers, judges, and victims, and it isn't rare for a single person to cross into multiple lists. And, theoretically, it is possible to be in all lists. For instance there are many prosecuting lawyers that become defense attorneys, and it is not unlikely that one of these attorneys could be a judge in the future. That scenario is very possible, and you can add it that a lawyer is very able to be a victim, and hell, we all know they can be criminals ;) Another scenario that happens very frequently, is that a person is both a defendant and a victim. I don't want the person entering data to scroll through hundreds, and eventually thousands, of names to pick an attorney's name from among the list of everybody else in the system. The idea I am working on presently is to add logical fields for each designation to the table of names. For instances: kNameID txtLastName txtFirstName txtMI txtSuffix logAttorney logADA logJudge logVictim logDefendant If I do this, I will have removed some fields that are currently there, such as: txtAddress1 txtAddress2 txtCity txtSt txtZip txtPhone And, I will put these in another linked table. There may be a need to have multiple addresses for the defendants, so this would be best I think. The problem that I am foreseeing here...I'm not at that point, so my fears could be unfounded...is setting these fields to true and/or false, as needed. Basically, thinking of victims for a minute here, the defendant screen, which will actually be an "Indictment" screen, will have a subform to hold potentially many victims for the indictment. If a victim IS already in the system as something else, I will need to tag that name as a victim and I'm wondering if this will present difficulties. Well, I hope I am being clear enough. If anyone out there has any tips for me, I would greatly appreciate it if you would pass them along. Thank you! John W Clark -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com - JENKENS & GILCHRIST E-MAIL NOTICE - This transmission may be: (1) subject to the Attorney-Client Privilege, (2) an attorney work product, or (3) strictly confidential. If you are not the intended recipient of this message, you may not disclose, print, copy or disseminate this information. If you have received this in error, please reply and notify the sender (only) and delete the message. Unauthorized interception of this e-mail is a violation of federal criminal law. This communication does not reflect an intention by the sender or the sender's client or principal to conduct a transaction or make any agreement by electronic means. Nothing contained in this message or in any attachment shall satisfy the requirements for a writing, and nothing contained herein shall constitute a contract or electronic signature under the Electronic Signatures in Global and National Commerce Act, any version of the Uniform Electronic Transactions Act or any other statute governing electronic transactions. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com - JENKENS & GILCHRIST E-MAIL NOTICE - This transmission may be: (1) subject to the Attorney-Client Privilege, (2) an attorney work product, or (3) strictly confidential. If you are not the intended recipient of this message, you may not disclose, print, copy or disseminate this information. If you have received this in error, please reply and notify the sender (only) and delete the message. Unauthorized interception of this e-mail is a violation of federal criminal law. This communication does not reflect an intention by the sender or the sender's client or principal to conduct a transaction or make any agreement by electronic means. Nothing contained in this message or in any attachment shall satisfy the requirements for a writing, and nothing contained herein shall constitute a contract or electronic signature under the Electronic Signatures in Global and National Commerce Act, any version of the Uniform Electronic Transactions Act or any other statute governing electronic transactions. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com