Question Patients previous addresses

[Greenboy]

Hi

Sorry if this is in the wrong forum.

I am pretty new to access and am putting together a patient list, and was wondering if any one gan provide some pointers on how to deal with an issue of patients moving house.

To ensure you have the correct patient it is sometimes useful to not only confirm their current address but also their previous address, and therefore when entering a change of address I do not want to loose their previous address

Any suggestions great fully recieved

 

[RuralGuy]

Re: Patients previous actress's

It sounds like you will need a Previous address table for the history.

 

[Greenboy]

Thanks RuralGuy - I take it I will need to copy the current address into the "previous address" table before entering the new details. Would this be done by vba or can this be done by some sort of update query?

Thanks again.

 

[RuralGuy]

It is basically archiving and can be done with an Append query before you update the current live table record.

 

[bparkinson]

Just build an Address table, with a one to many relationship between patient and address. Have a bit column for CurrentAddress. When they move, add their new address, and make it current. No need to copy any addresses this way, and one less table.

 

[RuralGuy]

Same number of tables just distributed differently. That was my first thought but felt the archiving idea was better. Just my $0.02.

 

[gemma-the-husky]

personally, I think for something like a previous address, managing a separate table with ALL the previous addresses might be overkill. I would expect you would never want to search for the old address.

If you already have an address table, then fine - but if not, I would just be inclined to store the old address in the same table as you store the current address.

In the form where you enter the new address, just have a bit of code that does

me.oldaddress = me.currentaddress - sort of thing

 

[Greenboy]

Thanks for the advice - Append Query is interesting, and so is the idea of just adding the new address and marking it as the 'current' address.

Either will work for me.

Thanks for your time and support.
Dave