[mso] Re: Database Integrity

either prepend or or add the vehicle year to the number.
-Jim-


Carol Parent wrote:

> Hello,
>
> I have a question concerning Database Integrity.  I hope this is an
> applicable topic.  If not please advise.
>
> I am creating a database of Vehicles/Activities/MilesDriven/FuelUsed for our
> local school system.  I need to be able to track which vehicle goes on what
> activity and track the amount of miles being racked up on the vehicles.
>
> Now that is not a big deal BUT when the school purchases a NEW vehicle they
> replace an old vehicle giving it the same number.  How can I protect the
> data integrity (i.e., relationship between vehicles/milesdriven/activity)
> but use the SAME NUMBER to identify a different vehicle?
>
> I am not very proficient with databases so am taking this very slowly as to
> hopefully not muck it up to much.
>
> Thanks very much for any advice/responses you may offer.
>
> Best regards,
>
> Carol Parent
> info@xxxxxxxxxxxxxxx
> http://www.carolparent.net
>
> I finally got it all together...
> I just wish I could remember where I set it down.
>
> -----Original Message-----
> From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx]On
> Behalf Of James LaBorde
> Sent: Monday, April 29, 2002 11:24 AM
> To: 'mso@xxxxxxxxxxxxx'
> Subject: [mso] Re: New to the List- Happy to be here. :VSMail MX2
>
> Peter,
>
> Good to see another Access person here.
>
> James
>
> -----Original Message-----
> From: Peter Chiavaro [mailto:kp@xxxxxxxx]
> Sent: Saturday, April 27, 2002 8:45 AM
> To: mso@xxxxxxxxxxxxx
> Subject: [mso] New to the List- Happy to be here. :VSMail MX2
>
> Hello Fellow Office Dweebs,
>
> This is my first post. (Hi Linda, Hi Dian).
>
> I am proficient with MS Access. I don't write code, but I can do
> just about everything else. Perhaps I can answer some of the basic
> MS Access questions / problems.
>
> More Later.
>
> Peter C.
> Equine Cooling Technician
> Alex Campbell Racing Stables
> Payson Park
> Indiantown, FL
>
> *************************************************************
> PLEASE READ!!!!
>
> This is not S*P*A*M!  You are receiving this mail because you either
> subscribed to mso@xxxxxxxxxxxxx or to it's earlier version,
> MicrosoftOffice@xxxxxxxxxxxxxxxx
>
> To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx
> with a subject line that says "unsubscribe" (without the quotes).  Do not
> put unsubscribe IN CAPS.  Screaming doesn't get you out any faster and the
> caps prevent the function from working.
>
> To change your email settings to digest or vacation (no mail), visit the
> group's homepage for full instructions.
>
> http://www.freelists.org/webpage/mso
> *************************************************************
> *************************************************************
> PLEASE READ!!!!
>
> This is not S*P*A*M!  You are receiving this mail because you either
> subscribed to mso@xxxxxxxxxxxxx or to it's earlier version,
> MicrosoftOffice@xxxxxxxxxxxxxxxx
>
> To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx
> with a subject line that says "unsubscribe" (without the quotes).  Do not
> put unsubscribe IN CAPS.  Screaming doesn't get you out any faster and the
> caps prevent the function from working.
>
> To change your email settings to digest or vacation (no mail), visit the
> group's homepage for full instructions.
>
> http://www.freelists.org/webpage/mso
> *************************************************************
>
> *************************************************************
> PLEASE READ!!!!
>
> This is not S*P*A*M!  You are receiving this mail because you either 
> subscribed to mso@xxxxxxxxxxxxx or to it's earlier version, 
> MicrosoftOffice@xxxxxxxxxxxxxxxx
>
> To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx 
> with a subject line that says "unsubscribe" (without the quotes).  Do not put 
> unsubscribe IN CAPS.  Screaming doesn't get you out any faster and the caps 
> prevent the function from working.
>
> To change your email settings to digest or vacation (no mail), visit the 
> group's homepage for full instructions.
>
> http://www.freelists.org/webpage/mso
> *************************************************************

--
-Jim-
n1jmm@xxxxxxxxxxxx
n1jmm@xxxxxxxxx
n1jmm@xxxxxxxx
n1jmm@xxxxxxx
n1jmm@xxxxxxxxxxx
n1jmm@xxxxxxxxxxxxx
http://www.callsign.net/n1jmm
http://www.bigfoot.com/~n1jmm


*************************************************************
PLEASE READ!!!!

This is not S*P*A*M!  You are receiving this mail because you either subscribed 
to mso@xxxxxxxxxxxxx or to it's earlier version, 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx with 
a subject line that says "unsubscribe" (without the quotes).  Do not put 
unsubscribe IN CAPS.  Screaming doesn't get you out any faster and the caps 
prevent the function from working.

To change your email settings to digest or vacation (no mail), visit the 
group's homepage for full instructions.

http://www.freelists.org/webpage/mso
*************************************************************

Other related posts: