Re: Database design help.

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

I'm sorry, I'm not following you. Here's a better example of what I am asking.

11/8/08 Jane Doe, 101 main st, mytown, il comes in and a contact note is
typed on her and saved.
12/21/08 Jane Doe (now Jane Smith), 125 South St, yourtown, il comes back
and another note is typed and saved.

I need to make sure that when Jane's name & address changed the original
note stayed the same.

Thanks again for any help. Sorry I'm not following you.



"Steve" wrote:

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

  • 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)
  • 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: Groups: Multiple Addresses Per Contact
    ... teacher and the address book is created by student names. ... You create a contact for John Doe. ... the parent as parent Doe. ...
    (microsoft.public.mac.office.entourage)
  • 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)