Re: Database design help.

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

TblClientDataNeverChanges
ClientDataNeverChangesID
<Client Data Fields That Never Change>

TblClientAlias
ClientAliasID
ClientDataNeverChangesID
VisitDate
Note

Steve


"kids23bball" <kids23bball@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:20876805-6C5F-4B3C-ABE6-FFD6E51F6B9D@xxxxxxxxxxxxxxxx
I am trying to make a db with client notes in it. My problem is I need to
be
able to track the client name changes. For example: client comes in
today
name is john doe, a note (form completed) is done and saved, now 3 months
later client comes in and name is john smith. I need the first note to
still
be saved as john doe and not changeable and make sure john doe and john
smith
are same person, which I have done by clientid. I want to be able to see
all
notes done by john doe and john smith. Sorry if this makes no sense. I
know
what I want just having trouble explaining. Thanks for any help.


.

Relevant Pages

  • Database design help.
    ... I am trying to make a db with client notes in it. ... later client comes in and name is john smith. ... be saved as john doe and not changeable and make sure john doe and john smith ... what I want just having trouble explaining. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Digital signatures
    ... If another person decide they're going to claim their John Doe, ... That's how every co-operative mail/PGP client I've used works. ... It'd take a war of words between the two people in a common forum for ... A printer configuration backend/frontend combination. ...
    (Fedora)
  • Re: Data Normalization
    ...     John Doe ... one column in a 10 column invoices table that tracks the name of the ... client and that is the only aspect of the client that you track, ... John Doe is not the same on all records. ...
    (microsoft.public.access.gettingstarted)
  • Re: Database design help.
    ... <Client Data Fields That Never Change> ... name is john doe, a note is done and saved, now 3 months ... later client comes in and name is john smith. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Mail relay question
    ... You could be the client of 3 ISP's at 3 different locations, using 3 different outgoing SMTP servers, and still use the same email address. ... read the SMTP RFC or google for simple examples / resources. ... my thought was that my wife will trust anything sent to her as ... So unless they know exactly what name you set (John Doe, Doe, John, JDoe, Johnny, etc), your wife will notice the difference from the previous emails and should get suspicious. ...
    (Security-Basics)