Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 06-16-2019, 10:58 AM   #16
billgyrotech
Newly Registered User
 
Join Date: Apr 2013
Posts: 244
Thanks: 60
Thanked 3 Times in 3 Posts
billgyrotech is on a distinguished road
Re: Data Protection Different Levels

Yes they do get returned sometimes under warranty

billgyrotech is offline   Reply With Quote
Old 06-16-2019, 11:08 AM   #17
billgyrotech
Newly Registered User
 
Join Date: Apr 2013
Posts: 244
Thanks: 60
Thanked 3 Times in 3 Posts
billgyrotech is on a distinguished road
Re: Data Protection Different Levels

The clerk will search history by serial number and part number when a unit arrives. There may be a duplicate serial number but not with part number criteria too.
billgyrotech is offline   Reply With Quote
Old 06-16-2019, 01:19 PM   #18
mike60smart
Newly Registered User
 
mike60smart's Avatar
 
Join Date: Aug 2017
Location: Dunbar, Scotland
Posts: 396
Thanks: 21
Thanked 87 Times in 86 Posts
mike60smart will become famous soon enough
Re: Data Protection Different Levels

Hi

Ok So 1 Customer Returns Many Items Which get Repaired and Returned to the Customer

This would indicate that you need more tables

Currently if a Customer returns the same item using your structure how do you manage it?

Do you Create a Completely New Record or over right the current Record?

mike60smart is offline   Reply With Quote
Old 06-16-2019, 01:26 PM   #19
billgyrotech
Newly Registered User
 
Join Date: Apr 2013
Posts: 244
Thanks: 60
Thanked 3 Times in 3 Posts
billgyrotech is on a distinguished road
Re: Data Protection Different Levels

A new AFR Number is created each time

billgyrotech is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Question Data Controller / Data Protection yus786 General 6 07-12-2010 01:50 AM
Multiple levels af data in forms svjensen General 10 05-10-2010 12:42 AM
data protection vs historical data help!!! handyman1 Tables 2 01-04-2007 10:30 AM
Protection against adding duplicate data wrek Forms 2 06-22-2001 10:52 AM
combining data for grouping levels Paulp Reports 1 01-24-2000 01:55 PM




All times are GMT -8. The time now is 12:19 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World