[AccessD] 2 quick questions

Stuart McLachlan stuart at lexacorp.com.pg
Fri May 27 17:51:43 CDT 2011


Sub myForm_BeforeUpdate()
  ..
   Hash = CalcHash(FName,Lname,MI,DOB)
   ...
End Sub

On 27 May 2011 at 10:39, Charlotte Foust wrote:

> The hash could never change in that case.  So what happens if the name
> changes and someone else comes in with the old name?  The mantra we
> always followed in my previous lives was "Always Check For Existing
> Keys First".
> 
> Charlotte
> 
> On Fri, May 27, 2011 at 8:28 AM, Stuart McLachlan
> <stuart at lexacorp.com.pg> wrote:
> > <quote>
> > And, there would have to be a quick search to see if this id is
> > already present. </quote>?
> >
> > Why not just put an index on the ffull name/dob fields or use a hash
> > of that info as a key. Then look that  up if you are checking for
> > duplicates.  It dioesn't have to be user readable.
> >
> > --
> > Stuart
> >
> > On 27 May 2011 at 10:24, John Clark wrote:
> >
> >> Well...yeah...they need to know when a child coming in has already
> >> been there, and what data they provided at that time.
> >>
> >> And, no, the person entering data does not enter the
> >> number/rule...it is done automagically after they enter the other
> >> data. And, there would have to be a quick search to see if this id
> >> is already present.
> >>
> >> >>> "Susan Harkins" <ssharkins at gmail.com> 5/26/2011 3:32 P >>>
> >> Do you really need this though? I mean... how are the users
> >> actually going to apply it? Are they going to have to memorize your
> >> rule and enter the string to id the patient?
> >>
> >> Susan H.
> >>
> >>
> >> > It is going to be used to track their clients. There are 3
> >> > alternate surveys, but I think each one can be given multiple
> >> > times. They want to track the clients and how their dental visit
> >> > habits change. So, I asked them if they want to know if these
> >> > same clients return and they are saying yes.
> >> >
> >> > So, if my example Joe T Murphy is entered as a 5 yr old, and they
> >> > return and take another survey at 10, and then at 15 and finally
> >> > at 20, they'll need a way to tell that this was the same person
> >> > each time.
> >>
> >> --
> >> 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
> >>
> >
> >
> >
> > --
> > 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
> 







More information about the AccessD mailing list